

Database Guide › Oracle Guidelines › Oracle Users › Manually Create a Search User
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:
- Enter a user name and password for the new user. You must supply these credentials when you install a CMS or gateway.
- 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:
Requirements for Oracle Users
Tablespaces for CA DataMinder
Copyright © 2014 CA.
All rights reserved.
 
|
|