Oracle DBA Role Requirements for WCCADMIN Account

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

Can the Oracle DBA role be removed from the WCCADMIN account used by AutoSys Workload Control Center (WCC)? What functionality depends on this role, and is it required for normal operations?

Environment

Product: AutoSys Workload Automation
Release: 12.x and above
Database: Oracle
Component: Workload Control Center (WCC)

Cause

Usually there are 2 different users, the schema owner (wccadmin) and the connect user (wcc)

Resolution

The Oracle DBA role is typically required for the WCCADMIN account (or the equivalent WCC schema owner) during the installation, upgrade, or patching of WCC. This is because the installer performs schema-level operations, such as creating tables, sequences, and views, which require elevated privileges.

Runtime Operations
For normal daily operations (runtime), the DBA role is generally not required for the WCCADMIN account. The account primarily requires the following standard privileges to function:

• CREATE SESSION
• CEATE VIEW
• CREATE PUBLIC SYNONYM
• CONNECT
• RESOURCE
• SELECT_CATALOG_ROLE (Optional, depending on specific reporting/monitoring features)
• QUOTA UNLIMITED on the WCC tablespace
• Explicit grants (SELECT, INSERT, UPDATE, DELETE, ALTER) on the WCC schema objects if a separate operational user is used.

Impact of Removing the DBA Role
If you remove the DBA role:

1. Functionality: Normal WCC operations (Monitoring, Quick Edit, Configuration) continue to work provided the standard grants listed above remain in place.
2. Maintenance: You must re-grant the DBA role (or use a different DBA-privileged account) before performing any AutoSys/WCC upgrades, service pack applications, or schema modifications.

If any unexpected issues arise after removing the DBA role from WCCADMIN (ensuring all documented grants are retained):

• Document the exact symptoms and any error messages observed.
• Provide specific details about the AutoSys version, WCC version, and Oracle database version.
• Consult with your database administrator to verify that all the explicitly listed grants for wccadmin are active and correctly applied.

Additional Information

To speak with a customer representative or a Support Engineer see Contact Support. Scroll to the bottom of the page and click on your respective region.