V11 SP8
Loading...

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.

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