The Oracle OS_ROLES parameter should be set to FALSE.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-2519	DO0240-ORACLE10	SV-24880r2_rule	DCSD-1	Low

Description
The OS_ROLES parameter specifies whether Oracle roles are defined and managed by the DBMS or by the host operating system. To maintain and support the separation of duties between host system administration and DBMS administration, the DBMS must be configured to use only roles defined and managed by the DBA. Separation of duties supports assignment of privileges by job function and supports accountability.

Description

The OS_ROLES parameter specifies whether Oracle roles are defined and managed by the DBMS or by the host operating system. To maintain and support the separation of duties between host system administration and DBMS administration, the DBMS must be configured to use only roles defined and managed by the DBA. Separation of duties supports assignment of privileges by job function and supports accountability.

STIG	Date
Oracle Database 10g Instance STIG	2014-04-02

Details

Check Text ( C-29432r4_chk )
From SQL*Plus: select value from v$parameter where name = 'os_roles'; If the value returned is not FALSE, this is a Finding.

Fix Text (F-26461r1_fix)
From SQLPlus: alter system set os_roles = FALSE scope = spfile; The above SQLPlus command will set the parameter to take effect at next system startup.