Previous Topic: Required Privileges for Oracle UsersNext Topic: Password Expiry

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
CONNECT ROLE

Only needed by the Search User.

SELECT CATALOG ROLE

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

Oracle System Privileges
ALTER SESSION

Needed by the Primary User and Schema Owner.

CREATE CLUSTER

Needed by the Primary User and Schema Owner.

CREATE ANY CONTEXT

Needed by the Primary User and Schema Owner.

CREATE DATABASE LINK

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 and Schema Owner.

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 to r12.5 and you intend to partition the database or you want to run Review Queue database searches.

More information:

Infrastructure-Based Purging