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

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

book

Article ID: 53009

calendar_today

Updated On: 06-16-2025

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