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

Products

• CA IT Asset Manager
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

This KB article explains what permissions the database user needs in order to install the MDB on Oracle.

Environment

CA Service Management 17.x

All Supported Oracle versions

Resolution

The Oracle user that runs the MDB installation must have the following database administrator privileges assigned:

• DBA role (connect sys as sysdba; grant dba to installation_user;)
• SYSDAB 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$

Additional Information

Installing CA Service Management 17.4