Database Guide › Oracle Guidelines › Oracle Users › Manually Create a Search User

Manually Create a Search User

To manually create an Oracle seach user

1. If you have not already done so, copy the files CreateOracleUser.sql and WgnSetupOwner.sql to a local folder.
2. From a command line, navigate to the host folder you chose in step 1 and run this command:

   sqlplusw
   

   This launches Oracle’s 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 commands:

   SQL>CREATE USER <SearchUser> IDENTIFIED BY “<Password>”DEFAULT TABLESPACE <Tablespace> QUOTA UNLIMITED ON <Tablespace>;
   SQL>GRANT CONNECT, SELECT_CATALOG_ROLE, CREATE SYNONYM TO <SearchUser>;
   

   Where <tablespace> must be an existing tablespace.

More information:

Requirements for Oracle Users

Tablespaces for CA DLP