Database Guide › Oracle Guidelines › Oracle Users › Manually Create an Unrestricted Search User

Manually Create an Unrestricted Search User

The procedure for manually creating the Unrestricted Search User for an Oracle CMS is similar to that for creating the Search User (see the previous section).

To manually create an Oracle Unrestricted Search User

1. If you have not already done so, copy the following files to a local folder:
   • CreateOracleRLSUser.sql
   • WgnSetupSearchUser.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:

   @CreateOracleRLSUser 
   

   The script prompts you for the following details:

   1. Enter a user name and password for the new user. You must supply these credentials if you enable the data warehouse when you install a CMS.
   2. Enter an existing tablespace.

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

5. If you want to change the password or tablespace, rerun the script now or at a later time.