Is the Oracle EXECUTE_CATALOG_ROLE required for the 'aedbadmin' database user?

book

Article ID: 17165

calendar_today

Updated On:

Products

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

Issue/Introduction



In the WAAE Oracle database, the 'aedbadmin' user has EXECUTE_CATALOG_ROLE granted. Is this privilege required or can it be revoked?

Environment

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

Resolution

The EXECUTE_CATALOG_ROLE privilege is no longer required for the 'aedbadmin' user in WAAE versions 11.3.5 or later. Provided that you are running WAAE 11.3.5 or later, this privilege can be safely revoked.