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;