Changes to configuration options must be audited.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-219868	O121-BP-025800	SV-219868r903020_rule		Medium

Description
When standard auditing is in use, 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.

STIG	Date
Oracle Database 12c Security Technical Implementation Guide	2023-06-01

Details

Check Text ( C-21579r903018_chk )
For Unified or mixed auditing, from SQLPlus: select count() from audit_unified_enabled_policies where entity_name = 'SYS'; If less than one row is returned, this is a finding. For Standard auditing, from SQL*Plus: select value from v$parameter where name = 'audit_sys_operations'; If the value returned is FALSE, this is a finding.

Fix Text (F-21578r903019_fix)
For Standard auditing, from SQLPlus: alter system set audit_sys_operations = TRUE scope = spfile; The above SQLPlus command will set the parameter to take effect at next system startup. If Unified Auditing is used: To ensure auditable events are captured: Link the oracle binary with uniaud_on, and then restart the database. Oracle Database Upgrade Guide describes how to enable unified auditing. For additional information on creating audit policies, refer to the Oracle Database Security Guide http://docs.oracle.com/database/121/DBSEG/audit_config.htm#CHDGBAAC

Fix Text (F-21578r903019_fix)

For Standard auditing, 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.

If Unified Auditing is used:
To ensure auditable events are captured:
Link the oracle binary with uniaud_on, and then restart the database. Oracle Database Upgrade Guide describes how to enable unified auditing.

For additional information on creating audit policies, refer to the Oracle Database Security Guide
http://docs.oracle.com/database/121/DBSEG/audit_config.htm#CHDGBAAC