V11 SP8
Loading...

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.

Privileges
DELETE ANY TABLE
CREATE ANY TABLE
INSERT ANY TABLE
SELECT ANY TABLE
CREATE DATABASE LINK
CREATE ANY DIRECTORY
ALTER ANY TABLE
CREATE SEQUENCE
CREATE VIEW
CREATE SESSION
UNLIMITED TABLESPACE

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