Oracle Database 11.2g Security Technical Implementation Guide

The Oracle Database 11.2g Security Technical Implementation Guide (V2 R5) has 142 STIG checks. New to STIG checklists? Read What is a STIG checklist?, CKL vs CKLB, and STIG vs SCAP benchmark.

Find STIG checks

142STIG checks

Search filters this STIG's checks locally. Separate terms must all match (use quotes for an exact phrase). A search you ran on the Search page carries over here.

Severity

Version

V2 · R5

CurrentPublished Wed Jul 24 2024

Changes to configuration options must be audited.

Oracle Database 11.2g Security Technical Implementation Guide

Assessment Title

Rule Text

Changes to configuration options must be audited.

Description

Discussion Text

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.

New to STIG checklists? Read What is a STIG checklist? and CKL vs CKLB.

Objective

V-219739

Rule

SV-219739r961863_rule

Severity

medium

Rule Version

O112-BP-025800

Documentable

false

IA Controls

NIST SP 800-53

Rev 5

Assessment Procedure

Check Text

From SQL*Plus:

select value from v$parameter where name = 'audit_sys_operations';

If the value returned is FALSE, this is a Finding.

Implementation Procedure

Fix Text

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.

STIG check 34 of 142 in the Oracle Database 11.2g STIG checklist

← Previous · V-219738Network access to the DBMS must be restricted to authorized personnel.Next · V-219742 →Changes to DBMS security labels must be audited.