2.2.1 Ensure 'AUDIT_SYS_OPERATIONS' Is Set to 'TRUE'

Information

The AUDIT_SYS_OPERATIONS setting provides for the auditing of all user activities conducted under the SYSOPER and SYSDBA accounts. The setting should be set to TRUE to enable this auditing.

If the parameter AUDIT_SYS_OPERATIONS is FALSE all statements except for Startup/Shutdown and Logon by SYSDBA / SYSOPER users are not audited.

Solution

To remediate this setting, execute the following SQL statement and restart the instance.

ALTER SYSTEM SET AUDIT_SYS_OPERATIONS = TRUE SCOPE=SPFILE;

See Also

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