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

Article Id: 36920
Status: Published
Updated On: 14-02-2018 07:37
Legacy Id: TEC1303672
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: