Privileges for CA_UIM schema user

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

What are the privileges required for CA_UIM schema user?

Environment

Release: Any DX UIM

Component: Data Engine

DB: Oracle

Resolution

Below are the privileges required for CA_UIM schema user.

 

GRANT unlimited tablespace to CA_UIM;
GRANT administer database trigger to CA_UIM;
GRANT create table to CA_UIM;
GRANT create any table to CA_UIM;
GRANT create view to CA_UIM;
GRANT alter any table to CA_UIM;
GRANT select any table to CA_UIM;
GRANT create sequence to CA_UIM;
GRANT create procedure to CA_UIM;
GRANT create session to CA_UIM;
GRANT create trigger to CA_UIM;
GRANT create type to CA_UIM;
GRANT drop any table to CA_UIM;
GRANT lock any table to CA_UIM;
GRANT select on sys.v_$session to CA_UIM;
GRANT execute on sys.dbms_lob to CA_UIM;
GRANT execute on DBMS_CRYPTO to CA_UIM;
GRANT execute on dbms_redefinition to CA_UIM;

 

Please check the privileges with below query:

 

(1) 

SELECT grantee, privilege, admin_option FROM dba_sys_privs

WHERE grantee = 'CA_UIM' ORDER BY privilege;

 

(2) 

SELECT grantee, owner, table_name AS object_name, privilege FROM dba_tab_privs

WHERE grantee = 'CA_UIM' ORDER BY object_name, privilege;