Grants required for WCC user in Oracle

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

What grants are required for WCC user in Oracle?

Environment

Component: ATSYS

Cause

Usually there are 2 different users, the schema owner (wccdbuser) and the connect user (wcc)

Resolution

For r12 release:

GRANT CREATE VIEW TO wccdbuser
GRANT CONNECT TO wccdbuser
GRANT RESOURCE TO wccdbuser
GRANT SELECT_CATALOG_ROLE TO wccdbuser
GRANT CREATE PUBLIC SYNONYM TO wccdbuser
GRANT CONNECT TO wcc          -- this is needed as we have the schema owner vs connect user
ALTER USER wccdbuser  QUOTA UNLIMITED ON wcctablespace_name

 

GRANT SELECT, INSERT, UPDATE, DELETE, ALTER ON wccdbuser.(all table names) TO wcc

GRANT SELECT ON wccadmin.SEQ_GEN_SEQUENCE TO wccdbuser.(all sequences) TO wcc

 

 

 

 

Additional Information

GRANT CREATE ANY SEQUENCE to WCC; 
GRANT CREATE TABLE to WCC; 
GRANT CREATE ANY INDEX to WCC; 
GRANT CREATE SESSION to WCC; 
GRANT ALTER ANY TABLE to WCC; 
GRANT DROP ANY INDEX to WCC; 
GRANT UNLIMITED TABLESPACE to WCC;