CA Client Automation ca_itrm Oracle User Roles and Privileges

Products

• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/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.

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.

 

 

Resolution

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