Audit records should be restricted to authorized individuals.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-5686	DG0032-ORACLE11	SV-24622r2_rule	ECTP-1	Medium

Description
Audit data is frequently targeted by malicious users as it can provide a means to detect their activity. The protection of the audit trail data is of special concern and requires restrictions to allow only the auditor and DBMS backup, recovery, and maintenance users access to it.

STIG	Date
Oracle Database 11g Instance STIG	2015-03-26

Details

Check Text ( C-26277r2_chk )
From SQLPlus: select value from v$parameter where name='audit_trail'; If none of the following values is displayed, this check is Not a Finding. Oracle 11.1 – 11.2 = 'db' Oracle 11.1 – 11.2 = 'db_extended' Review access granted to the AUD$ table. From SQLPlus: select grantee from dba_tab_privs where table_name = 'AUD$' and grantee not in ('DELETE_CATALOG_ROLE') and grantee not in (select grantee from dba_role_privs where granted_role = 'DBA') order by grantee; View access granted to the AUD$ table against those authorized in the System Security Plan. If any are not authorized, this is a Finding.

Check Text ( C-26277r2_chk )

From SQL*Plus:
select value from v$parameter where name='audit_trail';

If none of the following values is displayed, this check is Not a Finding.

Oracle 11.1 – 11.2 = 'db'
Oracle 11.1 – 11.2 = 'db_extended'

Review access granted to the AUD$ table.

From SQL*Plus:
select grantee from dba_tab_privs
where table_name = 'AUD$'
and grantee not in ('DELETE_CATALOG_ROLE')
and grantee not in
(select grantee from dba_role_privs
where granted_role = 'DBA')
order by grantee;

View access granted to the AUD$ table against those authorized in the System Security Plan.

If any are not authorized, this is a Finding.

Fix Text (F-2559r1_fix)
Document and authorize accounts granted access to the AUD$ table in the System Security Plan. Revoke access permissions granted to the AUD$ table from unauthorized users.