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?
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.