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

Last modified: 9/5/2018 12:42:14 PM