Does WCC DB user require the CREATE MATERIALIZED VIEW privilege?
Article ID: 16264
Updated On:
Products
CA Workload Automation AE - Business Agents (AutoSys)
CA Workload Automation AE - Scheduler (AutoSys)
CA Workload Automation Agent
Issue/Introduction
Our WCC DB user has the CREATE MATERIALIZED VIEW privilege - this has been flagged as security violation. Is this a required privilege for the WCC DB user?
Environment
CA Workload Control Center r11.4+
Resolution
The WCC DB user does not need the CREATE MATERIALIZED VIEW privilege to function properly with the application. Please note that if your WCC DB user has been assigned the DBA role, they will inherit the CREATE MATERIALIZED VIEW privilege.
Feedback
Yes
No
Powered by
