Home > IDERA ER/Studio TeamServer Database Creation – Oracle Edition – Pluggable Database – Final Edition

IDERA ER/Studio TeamServer Database Creation – Oracle Edition – Pluggable Database – Final Edition

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:

  1. Launch the IDERA ER/Studio Team Server Configurator located on the Desktop.
  2. Navigate to the database connection settings.
  3. Choose Oracle as the database type.
  4. Enter the connection details, including:
  5. Hostname or IP address of the Oracle Database server.
  6. Port number (default is 1521).
  7. Service name or SID of the Oracle Database instance.
  8. Username (erstudio) and password used in Step 2.
  9. 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.

 

 

 

Aligning complex data environments with business goals for over 30 years.
Copyright © 2024 Idera, Inc.