Description:
This document explains what the database user needs in order to install the MDB on Oracle.
Solution:
The Oracle user that runs the CA MDB installation must have the following database administrator privileges assigned:
The dba role (connect sys as sysdba; grant dba to installation_user;).
The sysdba role (connect sys as sysdba; grant sysdba to installation_user;).
The ability to grant privileges to the mdbadmin user to various system tables and views (connect sys as sysdba; grant all privileges on "sys". TABLE_NAME" to installation_user with grant option;). The values to be assumed by TABLE_NAME are:
COL$, DBA_CONSTRAINTS, DBA_CONS_COLUMNS, DBA_INDEXES, DBA_IND_COLUMNS, DBA_OBJECTS, DBA_OBJECT_TABLES, DBA_REGISTRY,DBA_TABLES,
DBA_TABLESPACES, DBA_TAB_COLUMNS, DBA_TAB_PRIVS, DBA_VIEWS, DBMS_REGISTRY, EXPDEPACT$, EXPDEPOBJ$, EXPPKGACT$,EXPPKGOBJ$, KOPM$,
OBJ$, TS$, USER$