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

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