6.2.18 Ensure AUDIT_ADMIN' Is Revoked From Unauthorized 'GRANTEE'

Information

The AUDIT_ADMIN privilege allows a user to manage database auditing policies and audit records. This role grants control over auditing configurations and access to audit trails.

Users with AUDIT_ADMIN can modify audit settings or delete audit records, potentially concealing unauthorized activities. Revoking this privilege from unauthorized users ensures that only designated administrators control audit policies, preventing audit log tampering.

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_ADMIN 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: fe3133a78ab98534eac719665b824f2fdc49c4017cfd6a91a4d100cb622dc831