Database Guide › Oracle Guidelines › Oracle Users › Manually Create a Schema Owner

Manually Create a Schema Owner

To manually create the Oracle schema owner before installing the CMS, you need the following files:

• CreateOracleUser.sql
• WgnSetupOwner.sql

The CreateOracleUser.sql script creates the schema owner and automatically grants the privileges that this Oracle user needs to access the database tables and manage the CMS database. To do this, the script calls and invokes a stored procedure in WgnSetupOwner.sql. Find these files in the \Support folder on your CA DLP distribution media.

To manually create an Oracle schema owner

1. Copy CreateOracleUser.sql and WgnSetupOwner.sql from your CA DLP distribution media to a local folder.

   This step is necessary because a log file is written to the host folder when you run the CreateOracleUser.sql script.

2. From a command line, navigate to the host folder you chose in step 1 and run this command:

   sqlplusw
   

   This launches the Oracle SQL Plus utility and sets the correct working directory for the script execution.

3. In SQL Plus, connect to the CA DLP database as a user with sysdba privileges.
4. Run the following command:

   @CreateOracleUser
   

   The script prompts you for:

   • A user name and password for the new Oracle schema owner. You need to supply these credentials when you install your CMS and gateway servers.
   • A tablespace. This must be an existing tablespace. See also the tablespace recommendation in Tablespaces for CA DLP.

   Finally, the script outputs a summary of the new account.

5. If you want to change the password or tablespace, rerun the script now.

   Important! You cannot change the password or tablespace after you have installed the CMS!

More information:

Tablespaces for CA DLP

Storage: Oracle Default Tablespace Configuration