database Roles and Privileges

Products

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

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 AEDB_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 AEDB_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.