Database Guide › Oracle Guidelines › Oracle Users › Requirements for Oracle Users › Required Privileges for Oracle Users

Required Privileges for Oracle Users

The Oracle primary user, search user and schema owner require appropriate privileges to manage the CMS database. For example, the primary user and schema owner need SELECT privileges on all data dictionary views; to allow this access, they must have the SELECT CATALOG role.

Automatically granted privileges

All required privileges are granted automatically when you install a new CMS or when you run the CreateOracleUser.sql script. But you must manually grant some privileges if upgrading your CMS.

Manually granted privileges

If upgrading from 12.0, you must grant:

• CREATE MATERIALIZED VIEW

If upgrading from 6.0, you must grant:

• CREATE JOB
• CREATE MATERIALIZED VIEW
• EXECUTE ON DBMS_LOCK
• SELECT ANY DICTIONARY

Note: These privileges are granted automatically when you install a new CMS.

More information:

Infrastructure-Based Purging