What permissions does the database user need when installing the MDB on Oracle?

Document ID : KB000053009
Last Modified Date : 14/02/2018
Show Technical Document Details

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$