Howdy!
In today’s blog post we will carry on with the actual setup and scripts needed to create the repository user and the instructions for IDERA ER/Studio TeamServer Repository Setup.
In this guide, we’ll walk you through the process of connecting to your Oracle Pluggable Database (PDB) named TeamServer and configuring permissions for IDERA ER/Studio Team / Pro Editions. Let’s dive in!
Step 1: Connect to SQL*Plus and Verify PDB Name
First, open SQL*Plus and connect to your Oracle Database instance. Ensure that you are connected to the correct Pluggable Database (PDB) named TeamServer by executing the following SQL command:
SELECT name FROM v$pdbs;
Verify that the name displays as TeamServer.
Step 2: User Creation and Permissions Setup
Issue the following SQL statements to create a new user and grant necessary permissions for IDERA ER/Studio TeamServer:
CREATE USER erstudio IDENTIFIED BY YourStrongPassword;
GRANT CONNECT, resource TO erstudio;
GRANT SELECT_CATALOG_ROLE TO erstudio;
GRANT CREATE INDEXTYPE TO erstudio;
GRANT CREATE PROCEDURE TO erstudio;
GRANT CREATE SEQUENCE TO erstudio;
GRANT CREATE SESSION TO erstudio;
GRANT CREATE SYNONYM TO erstudio;
GRANT CREATE TABLE TO erstudio;
GRANT CREATE TRIGGER TO erstudio;
GRANT CREATE TYPE TO erstudio;
GRANT CREATE VIEW TO erstudio;
GRANT UNLIMITED TABLESPACE TO erstudio;
GRANT EXECUTE ON DBMS_SQL TO erstudio;
GRANT EXECUTE ON DBMS_LOB TO erstudio;
GRANT EXECUTE ON DBMS_RANDOM TO erstudio;
Step 3: Configuration Using the Configurator
Once the user and permissions are set up, you can proceed to configure the Oracle connection using the IDERA ER/Studio TeamServer Configurator. Follow these steps:
- Launch the IDERA ER/Studio Team Server Configurator located on the Desktop.
- Navigate to the database connection settings.
- Choose Oracle as the database type.
- Enter the connection details, including:
- Hostname or IP address of the Oracle Database server.
- Port number (default is 1521).
- Service name or SID of the Oracle Database instance.
- Username (erstudio) and password used in Step 2.
- Test the connection to ensure successful connectivity.
Step 4: Final Checks
Perform a final check to ensure everything is set up correctly:
Congratulations! You have successfully configured Oracle Pluggable Database permissions for IDERA ER/Studio Team / Pro Editions.
Now you can leverage the powerful features of IDERA ER/Studio TeamServer.