6.1.12 Ensure the 'GRANT ANY PRIVILEGE' Audit Option Is Enabled

Information

GRANT ANY PRIVILEGE allows a user to grant any system privilege, including the most powerful privileges typically available only to administrators - to change the security infrastructure, to drop/add/modify users and more.

Rationale:

Auditing the use of this privilege is part of a comprehensive auditing policy that can help in detecting issues and can be useful in forensics.

Solution

To remediate this setting, execute the following SQL statement in either the non multi-tenant or container database, it does NOT need run in the pluggable.

AUDIT GRANT ANY PRIVILEGE;

Notes:

This does NOT audit all attempts to grant or revoke system privileges since this can also be done by anyone who was granted a system privilege with the admin option. Also, this never creates an audit record for anyone who does not hold the GRANT ANY PRIVILEGE system privilege. Thus, many attempts, successful or not, to grant and revoke system privileges are not audited by this.

See Also

https://workbench.cisecurity.org/files/2741