Information
The OLAP_DBA role allows grantees to perform Oracle OLAP administration tasks. Unauthorized access can impact analytical workspaces.
Users with this role can alter OLAP settings potentially impacting business intelligence applications.
Solution
To remediate this setting, execute the following SQL statement, keeping in mind if this is granted in both container and pluggable database, you must connect to both places to revoke. Please ensure proper impact analysis is done before revoking the privilege from a role.
REVOKE OLAP_DBA FROM <grantee>;
In the case of a grant via a role:
REVOKE <rolename> FROM <grantee>;