Adding or Revoking OCPSUB Access
You can grant or revoke a single user's access to the ocpsub proxy database account at any time by running the ocl_grant_revoke_OCPSUB.sql script.
To run the script ocl_grant_revoke_ocpsub.sql:
-
Log on to the operating system.
-
Set environment variables for the database name and code environment; see Setting Environment Variables on the Command Line
-
Change to the RXC_INSTALL directory:
cd %RXC_INSTALL%
-
Connect to SQL*Plus as
system
:sqlplus system
-
Run the script:
ocl_grant_revoke_ocpsub.sql
The script prompts for:
-
the exact username
-
an indication of whether you want to grant the privilege to the user (enter
1
) or revoke it (enter0
).
Parent topic: Setting Up User Accounts