Does WCC DB user require the CREATE MATERIALIZED VIEW privilege?

book

Article ID: 16264

calendar_today

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.