6.2.19 Ensure 'AUDIT_VIEWER' Is Revoked From Unauthorized 'GRANTEE'

Information

The AUDIT_VIEWER privilege allows users to view audit records without modifying them. This role is designed for read-only access to audit logs.

Unauthorized access to audit logs can expose sensitive information and compromise audit integrity. Revoking this privilege from unauthorized users prevents unnecessary exposure of audit records and enhances data security.

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 AUDIT_VIEWER FROM <grantee>;

In the case of a grant via a role:

REVOKE <rolename> FROM <grantee>;

See Also

https://workbench.cisecurity.org/benchmarks/16474

Item Details

Category: ACCESS CONTROL, MEDIA PROTECTION

References: 800-53|AC-3, 800-53|AC-5, 800-53|AC-6, 800-53|MP-2, CSCv7|14.6

Plugin: OracleDB

Control ID: 95ef8e868c19d86295319ff7dc2a8c1247b894d32c14e85bbe36e7524a9f4531