Manually Create a Search User

This section describes how to create a Search User for an Oracle CMS.

To manually create an Oracle Search User

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.
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.
In SQL*Plus, connect to the CA DataMinder database as a user with sysdba privileges.
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 when you install a CMS or gateway.
2. Enter an existing tablespace.
Finally, the script outputs a summary of the new user account.
If you want to change the password or tablespace, rerun the script now or at a later time.

More information: