Assigning the Required Privileges for the Archive Database Archive User

You should assign the DBA role to the archive database user.

Note: Oracle requires that you explicitly add the UNLIMITED TABLESPACE privilege to the user even when you assign the DBA role.

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

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>;