The Oracle O7_DICTIONARY_ACCESSIBILITY parameter should be set to FALSE.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-2586	DO3685-ORACLE10	SV-24936r1_rule	ECAN-1	Low

Description
The database data dictionary tables contain the data used by the database for database functions including database authentication and authorization as well as database configuration and control. By default, the parameter O7_DICTIONARY_ACCESSIBILITY is set to FALSE to prevent accounts with the privilege SELECT ANY TABLE from selecting the data dictionary tables. This setting protects the data dictionary from unintended access authorization by requiring full system privileges or direct table access permissions.

Description

The database data dictionary tables contain the data used by the database for database functions including database authentication and authorization as well as database configuration and control. By default, the parameter O7_DICTIONARY_ACCESSIBILITY is set to FALSE to prevent accounts with the privilege SELECT ANY TABLE from selecting the data dictionary tables. This setting protects the data dictionary from unintended access authorization by requiring full system privileges or direct table access permissions.

STIG	Date
Oracle 10 Database Instance STIG	2014-01-14

Details

Check Text ( None )
None

Fix Text (F-26548r1_fix)
Disable O7_dictionary_accessibility to restrict access to system tables to users granted privileges to access objects owned by all users. From SQLPlus: alter system set O7_dictionary_accessibility = FALSE scope = spfile; The above SQLPlus command will set the parameter to take effect at next system startup.