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

Article Id: 53009

Status: Published

Updated On: 21-03-2018 06:17

Legacy Id: TEC494981

Products:

CA IT Asset Manager , CA Software Asset Manager (CA SAM) , ASSET PORTFOLIO MGMT- SERVER , SUPPORT AUTOMATION- SERVER , CA Service Desk Manager - Unified Self Service , KNOWLEDGE TOOLS , CA Service Management - Asset Portfolio Management , CA Service Management - Service Desk Manager

Issue/Introduction:

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$

Environment:

Release:
Component: ARGIS