ORA-01950: no privileges on tablespace 'AEDB_DATA' during upgrade from 11.3.x to 11.3.6 of Workload Automation Autosys AE.

Products

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

Issue/Introduction

Question:

 

Which privileges need to be granted to get rid of error ORA-01950: no privileges on tablespace 'AEDB_DATA'?

This  error message is displayed during an upgrade of 11.3 to 11.3.6 of Workload Automation AE.

Answer:

The aedbadmin user needs the following rights:

GRANT DBA TO aedbadmin;

GRANT CREATE SESSION TO aedbadmin;

GRANT SELECT ON "SYS"."DBA_TABLESPACES" TO aedbadmin WITH GRANT OPTION;

 

 

Environment

Release: ATSYHA99000-11.3.6-Workload Automation AE-High Availability Option
Component: