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.

Rationale:

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;

Default Value:

TRUE

See Also

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