DG0142-ORACLE11 - Changes to configuration options must be audited - 'audit_sys_operations = true'

Information

The AUDIT_SYS_OPERATIONS parameter is used to enable auditing of actions taken by the user SYS. The SYS user account is a shared account by definition and holds all privileges in the Oracle database. It is the account accessed by users connecting to the database with SYSDBA or SYSOPER privileges.

Solution

From SQL*Plus:

alter system set audit_sys_operations = TRUE scope = spfile;

The above SQL*Plus command will set the parameter to take effect at next system startup.

See Also

https://dl.dod.cyber.mil/wp-content/uploads/stigs/zip/U_Oracle_Database_11g_Y21M10_STIG.zip

Item Details

References: CAT|II, Rule-ID|SV-24805r3_rule, STIG-ID|DG0142-ORACLE11, Vuln-ID|V-15645

Plugin: OracleDB

Control ID: 7f77ecc7608fec6c9112889337e2660b002aa7e535e3424770c36fb79c334ca8