Does WCC DB user require the CREATE MATERIALIZED VIEW privilege?

Document ID : KB000016264
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

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+
Answer:

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.