Information
The DV_ADMIN role allows users to configure Database Vault policies and manage security controls. Unauthorized access can weaken security
This role should be restricted to authorized administrators, as unauthorized use can lead to alteration or deletion of established 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_ADMIN FROM <grantee>;
In the case of a grant via a role:
REVOKE <rolename> FROM <grantee>;