Content

The following minimum system privileges are required to create and maintain the Optim directory on an Oracle 11g, 12c or higher database. (In the following list, optimdirowner is the owner of the Optim directory in the Oracle database. Replace optimdirowner with the appropriate value for your environment.):

• CREATE TABLE
• CREATE SESSION
• CREATE PROCEDURE
• UNLIMITED TABLESPACE
• GRANT select on DBA_TABLESPACES TO optimdirowner
• CREATE VIEW (Optim v11.3 only)

Additional privileges to create and maintain Optim DB Aliases for Oracle.

Creating and maintaining a DB Alias for an Oracle database normally requires SELECT ANY DICTIONARY privilege. However, as an alternative, you can grant the following individual privileges to create and maintain Optim DB Aliases. These CATALOG OBJECT privileges must be granted by a user with DBA privileges. (In the following list, optimdirowner is the owner of the Optim directory in the Oracle database. Replace optimdirowner with the appropriate value for your environment.)

For Oracle 11g:

• grant select on v_$database to optimdirowner;
• grant select on ALL_OBJECTS to optimdirowner;
• grant select on ALL_XML_TAB_COLS to optimdirowner;
• grant select on dba_encrypted_columns to optimdirowner;
• grant select on SYS.ACCESS$ to optimdirowner;
• grant select on SYS.CCOL$ to optimdirowner;
• grant select on SYS.CDEF$ to optimdirowner;
• grant select on SYS.COL$ to optimdirowner;
• grant select on SYS.CON$ to optimdirowner;
• grant select on SYS.DBA_USERS to optimdirowner;
• grant select on SYS.DEFSUBPART$ to optimdirowner;
• grant select on SYS.DEPENDENCY$ to optimdirowner;
• grant select on SYS.ENC$ to optimdirowner; See Note 1 below.
• grant select on SYS.ERROR$ to optimdirowner;
• grant select on SYS.ICOL$ to optimdirowner;
• grant select on SYS.IND$ to optimdirowner;
• grant select on SYS.INDCOMPART$ to optimdirowner;
• grant select on SYS.INDPART$ to optimdirowner;
• grant select on SYS.INDSUBPART$ to optimdirowner;
• grant select on SYS.JIJOIN$ to optimdirowner;
• grant select on SYS.LOB$ to optimdirowner;
• grant select on SYS.LOBCOMPPART$ to optimdirowner;
• grant select on SYS.LOBFRAG$ to optimdirowner;
• grant select on SYS.OBJ$ to optimdirowner;
• grant select on SYS.OPQTYPE$ to optimdirowner;
• grant select on SYS.PARTCOL$ to optimdirowner;
• grant select on SYS.PARTLOB$ to optimdirowner;
• grant select on SYS.PARTOBJ$ to optimdirowner;
• grant select on SYS.SEG$ to optimdirowner;
• grant select on SYS.SEQ$ to optimdirowner;
• grant select on SYS.SOURCE$ to optimdirowner;
• grant select on SYS.SUBPARTCOL$ to optimdirowner;
• grant select on SYS.SYN$ to optimdirowner;
• grant select on SYS.SYS_FBA_FA to optimdirowner;
• grant select on SYS.SYS_FBA_TRACKEDTABLES to optimdirowner;
• grant select on SYS.TAB$ to optimdirowner;
• grant select on SYS.TABCOMPART$ to optimdirowner;
• grant select on SYS.TABPART$ to optimdirowner;
• grant select on SYS.TABSUBPART$ to optimdirowner;
• grant select on SYS.TRIGGER$ to optimdirowner;
• grant select on SYS.TS$ to optimdirowner;
• grant select on SYS.USER$ to optimdirowner; See Note 1 below.
• grant select on SYS.USER_INDEXES to optimdirowner;
• grant select on SYS.USER_LOBS to optimdirowner;
• grant select on SYS.USER_TABLES to optimdirowner;
• grant select on SYS.VIEW$ to optimdirowner;

For Oracle 12c and higher:

• grant select on v_$database to optimdirowner;
• grant select on ALL_OBJECTS to optimdirowner;
• grant select on ALL_XML_TAB_COLS to optimdirowner;
• grant select on dba_encrypted_columns to optimdirowner;
• grant select on SYS.ACCESS$ to optimdirowner;
• grant select on SYS.CCOL$ to optimdirowner;
• grant select on SYS.CDEF$ to optimdirowner;
• grant select on SYS.COL$ to optimdirowner;
• grant select on SYS.CON$ to optimdirowner;
• grant select on SYS.DBA_USERS to optimdirowner;
• grant select on SYS.DEFSUBPART$ to optimdirowner;
• grant select on SYS.DEPENDENCY$ to optimdirowner;
• grant select on SYS.ENC$ to optimdirowner; See Note 1 below.
• grant select on SYS.ERROR$ to optimdirowner;
• grant select on SYS.ICOL$ to optimdirowner;
• grant select on SYS.IND$ to optimdirowner;
• grant select on SYS.INDCOMPART$ to optimdirowner;
• grant select on SYS.INDPART$ to optimdirowner;
• grant select on SYS.INDSUBPART$ to optimdirowner;
• grant select on SYS.JIJOIN$ to optimdirowner;
• grant select on SYS.LOB$ to optimdirowner;
• grant select on SYS.LOBCOMPPART$ to optimdirowner;
• grant select on SYS.LOBFRAG$ to optimdirowner;
• grant select on SYS.OBJ$ to optimdirowner;
• grant select on SYS.OPQTYPE$ to optimdirowner;
• grant select on SYS.PARTCOL$ to optimdirowner;
• grant select on SYS.PARTLOB$ to optimdirowner;
• grant select on SYS.PARTOBJ$ to optimdirowner;
• grant select on SYS.SEG$ to optimdirowner;
• grant select on SYS.SEQ$ to optimdirowner;
• grant select on SYS.SOURCE$ to optimdirowner;
• grant select on SYS.SUBPARTCOL$ to optimdirowner;
• grant select on SYS.SYN$ to optimdirowner;
• grant select on SYS.SYS_FBA_FA to optimdirowner;
• grant select on SYS.SYS_FBA_TRACKEDTABLES to optimdirowner;
• grant select on SYS.TAB$ to optimdirowner;
• grant select on SYS.TABCOMPART$ to optimdirowner;
• grant select on SYS.TABPART$ to optimdirowner;
• grant select on SYS.TABSUBPART$ to optimdirowner;
• grant select on SYS.TRIGGER$ to optimdirowner;
• grant select on SYS.TS$ to optimdirowner;
• grant select on SYS.USER$ to optimdirowner; See Note 1 below.
• grant select on SYS.USER_INDEXES to optimdirowner;
• grant select on SYS.USER_LOBS to optimdirowner;
• grant select on SYS.USER_TABLES to optimdirowner;
• grant select on SYS.VIEW$ to optimdirowner;

Note 1: Staring with the 11.3.0.5 release of Optim, this is not required for Oracle 11.2 and higher.