This document explains what the database user needs in order to install the MDB on Oracle.
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$