IDERA ER/Studio TeamServer データベース作成 - Oracle Edition - プラガブルデータベース - ファイナルエディション

Step 1: Connect to SQL*Plus and Verify PDB Name

In this step, you will verify that you’re connected to the correct Oracle Pluggable Database (PDB).

• Connect to SQL*Plus
  Open SQL*Plus and connect to your Oracle Database instance.

Verify the PDB Name
Run the following command to ensure you are connected to the correct PDB, named “TeamServer”:

SELECT name FROM v$pdbs;

• Make sure the name displayed is “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

After user creation, configure the Oracle connection using the IDERA ER/Studio TeamServer Configurator.

• Launch Configurator
  Open the Configurator from your desktop.
• Database Connection Settings
  Navigate to the database connection section and follow these steps:
  • Choose オラクル as the database type.
  • Enter the connection details, including:
    • Hostname/IP address of the Oracle server.
    • Port number (default is 1521).
    • Service name または SID.
    • Username (erstudio) and password (set earlier).
• Test Connection
  Confirm the setup by testing the connection.

Step 4: Final Checks and Setup Completion

Perform final checks to verify everything is configured correctly.

• Congratulations! You have successfully set up Oracle PDB permissions for IDERA ER/Studio Team / Pro Editions.

Now, you can fully utilize the features of IDERA ER/Studio TeamServer.

Conclusion: Streamlining Oracle PDB Setup for IDERA ER/Studio

By following the steps outlined in this guide, you have successfully connected to your Oracle Pluggable Database, created the necessary user, and configured permissions for IDERA ER/Studio TeamServer. This setup ensures that your database environment is ready for seamless collaboration and データ管理 within the ER/Studio ecosystem. 

With this foundation in place, your organization can leverage the full capabilities of IDERA ER/Studio to enhance productivity and governance in managing data assets.