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.

To manually create an Oracle schema owner

1. If you have not already done so, copy the following files to a local folder:
   • CreateOracleUser.sql
   • WgnSetupOwner.sql

   Find these files in the \Support folder of your CA DataMinder distribution image.

2. From a command line, change to the folder that you chose in step 1. Then 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 DataMinder database as a user with sysdba privileges.
4. Run the following command:

   @CreateOracleUser
   

   The script prompts you for the following details:

   1. Enter a user name and password for the new user. You must supply these credentials when you install a CMS or gateway.
   2. Enter an existing tablespace. See also the recommendation in Tablespaces for CA DataMinder.

   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 DataMinder