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:

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 CA Service Desk Manager 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