ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

CA Client Automation ca_itrm Oracle User Roles and Privileges

book

Article ID: 41299

calendar_today

Updated On:

Products

CA Automation Suite for Data Centers - Configuration Automation CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Remote Control CA Client Automation - Asset Intelligence CA Client Automation - Desktop Migration Manager CA Client Automation - Patch Manager

Issue/Introduction

Introduction: 

Client Automation uses the specific Oracle user ca_itrm created on the database level to get authenticated for MDB access.

This user is created automatically by DSM schema during "Install MDB" and Client Automation installation dialogs with a set of roles and privileges.

 

Question: 

What are the ca_itrm Oracle user roles and privileges created by DSM schema?

 

Environment:  

CA Client Automation - All Windows/Linux/Unix versions with Oracle database

 

Answer: 

CREATE USER ca_itrm PROFILE DEFAULT IDENTIFIED BY "NOT_changedR11"  ACCOUNT UNLOCK;

GRANT CREATE PROCEDURE TO ca_itrm;

GRANT CREATE PUBLIC SYNONYM TO ca_itrm;

GRANT CREATE SEQUENCE TO ca_itrm;

GRANT CREATE SESSION TO ca_itrm;

GRANT CREATE TABLE TO ca_itrm;

GRANT CREATE TYPE TO ca_itrm;

GRANT CREATE VIEW TO ca_itrm;

GRANT DELETE ANY TABLE TO ca_itrm;

GRANT DROP PUBLIC SYNONYM TO ca_itrm;

GRANT UNLIMITED TABLESPACE TO ca_itrm;

GRANT CREATE TRIGGER TO ca_itrm;

GRANT "CONNECT" TO ca_itrm;

-- *******************************************

-- setup role ca_itrm_group

-- *******************************************

-- CREATE ROLE ca_itrm_group;      

GRANT "CA_ITRM_GROUP" TO "CA_ITRM";

-- *******************************************

-- setup user ca_itrm_ams

-- *******************************************

CREATE USER ca_itrm_ams IDENTIFIED BY "CA_ITRM_AMS";

GRANT CREATE SESSION TO ca_itrm_ams;

-- *******************************************

-- setup role ca_itrm_group_ams

-- *******************************************

-- CREATE ROLE ca_itrm_group_ams;   

GRANT "CA_ITRM_GROUP_AMS" TO "CA_ITRM_AMS";

-------------

Additional Information:

<Please see attached file for image>

Oracleuserprivilegesandroles1.jpg


<Please see attached file for image>

Oracleuserprivilegesandroles2.jpg

 

<Please see attached file for image>

Oracleuserprivilegesandroles3.jpg

 

Environment

Release: UASIT.99000-12.8-Asset Intelligence
Component:

Attachments

1558721870761000041299_sktwi1f5rjvs16w8q.jpeg get_app
1558721869059000041299_sktwi1f5rjvs16w8p.jpeg get_app
1558721866813000041299_sktwi1f5rjvs16w8o.jpeg get_app