Assigning the Required Privileges for the Production Database Connect User

Assign the database administrator (DBA) role to the production database user.

If there is a reason that you cannot assign the DBA role to the production database user, assign the roles and privileges that are defined in the table.

Note: Oracle requires that you add the UNLIMITED TABLESPACE and SELECT ANY TABLE privilege to the user.

Example

• Use the following commands to add the user defined roles in Oracle.

  CREATE ROLE <ROLENAME>;
   GRANT CREATE SESSION TO <ROLENAME>; 
   GRANT CREATE DATABASE LINK TO <ROLENAME>; 
   GRANT UNLIMITED TABLESPACE TO <ROLENAME>; 
   GRANT SELECT ANY TABLE TO <ROLENAME>; 
   GRANT CREATE ANY TABLE TO <ROLENAME>; 
   GRANT ALTER ANY TABLE TO <ROLENAME>; 
   GRANT DELETE ANY TABLE TO <ROLENAME>; 
   GRANT CREATE VIEW TO <ROLENAME>; 
   GRANT INSERT ANY TABLE TO <ROLENAME>; 
   GRANT CREATE ANY DIRECTORY TO <ROLENAME>; 
   GRANT CREATE SEQUENCE TO <ROLENAME>;