Database Guide › Oracle Guidelines › Oracle Users › Requirements for Oracle Users › Privilege and Role Summary

Privilege and Role Summary

The Oracle Primary User, Search User, and Schema Owner need the following privileges and roles:

Oracle Roles

SELECT CATALOG ROLE

Needed by the Primary User, Schema Owner, Search User, Unrestricted User and Reporting User.

Oracle System Privileges

ALTER SESSION

Needed for the Primary User, Schema Owner, Search User, Unrestricted User and Reporting /user.

CREATE CLUSTER

Needed by the Primary User and Schema Owner.

CREATE ANY CONTEXT

Needed by the Primary User and Schema Owner.

CREATE JOB

Needed by the Primary User and Schema Owner.

Grant manually if upgrading from 6.0.

CREATE MATERIALIZED VIEW

Needed by the Primary User and Schema Owner.

Grant manually if upgrading from 6.0 or r12.0.

CREATE PROCEDURE

Needed by the Primary User and Schema Owner.

CREATE ROLE

Needed by the Primary User and Schema Owner.

CREATE SEQUENCE

Needed by the Primary User and Schema Owner.

CREATE SESSION

Needed for the Primary User, Schema Owner, Search User, Unrestricted User and Reporting User.

Note: The CREATE SESSION privilege is granted directly to New Search User accounts created for CA DataMinder 14.1 or later. Search User accounts created for earlier versions of CA DLP were granted this privilege indirectly via the CONNECT ROLE.

CREATE SYNONYM

Needed for the Primary User, Search User and Schema Owner.

CREATE TABLE

Needed for the Primary User and Schema Owner.

CREATE TRIGGER

Needed for the Primary User and Schema Owner.

CREATE VIEW

Needed for the Primary User and Schema Owner.

CREATE TYPE

Needed for the Primary User and Schema Owner.

DROP ANY ROLE

Only needed by the Schema Owner for de-installation.

DROP ANY CONTEXT

Only needed by the Schema Owner for de-installation.

QUERY REWRITE

Needed for the Primary User and Schema Owner.

Needed to create function indexes.

SELECT ANY DICTIONARY

Needed for the Primary User and Schema Owner.

Grant manually if upgrading from 6.0.

Oracle Object Privilege

EXECUTE ON DBMS_LOCK

Needed by the Primary User and Schema Owner.

Grant manually if upgrading and you intend to partition the database or you want to run Review Queue database searches.

More information:

Infrastructure-Based Purging

Requirements for Oracle Import and Export Utilities