Information
The DV_POLICY_OWNER privilege allows a user to own and manage security policies within Oracle Database Vault. This role provides control over security policies and rules governing database access.
Users with DV_POLICY_OWNER can modify security policies, potentially weakening database security. Revoking this privilege from unauthorized users ensures that only security administrators manage security policies.
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 DV_POLICY_OWNER FROM <grantee>;
In the case of a grant via a role:
REVOKE <rolename> FROM <grantee>;