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.

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;

See Also

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