database Roles and Privileges

book

Article ID: 142514

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - System Agent (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent CA Workload Automation AE

Issue/Introduction

The following errors are seen:


[12/30/2019 00:00:00]     CAUAJM_E_18402 ORA-01950: no privileges on tablespace 'USERS'
[12/30/2019 00:00:00]     CAUAJM_I_18403 Processing OCI function OEXEC, OEXN(3)

 

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

The message suggests the autosys user has their default tablespaces set to users instead of aedb_data and they currently lack access to it.
Consult the dba to grant the user(s) aedbadmin and autosys access to the users tablespace or if that is the incorrect tablespace adjust their default tablespace values. 

something like...

alter user aedbadmin default tablespace AEDBA_DATA;
alter user aedbadmin quota unlimited on AEDB_DATA;
alter user aedbadmin quota unlimited on AEDB_INDEX;
GRANT UNLIMITED TABLESPACE TO aedbadmin;

alter user autosys default tablespace AEDBA_DATA;
alter user autosys quota unlimited on AEDB_DATA;
alter user autosys quota unlimited on AEDB_INDEX;
GRANT UNLIMITED TABLESPACE TO autosys;

If the user has a default tablespace other than AEDB_DATA then grant them access to that tablespace instead and/or as well.