The Oracle RESOURCE_LIMIT parameter should be set to TRUE.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-2593	DO3696-ORACLE10	SV-24941r2_rule	ECLO-1	Medium

Description
The Oracle RESOURCE_LIMIT parameter determines whether resource limits are enforced in database profiles. If Oracle resource limits are disabled, any defined profile limits will be ignored. NOTE: This does not apply to password resources.

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

Details

Check Text ( C-29486r2_chk )
From SQL*Plus: select value from v$parameter where name = 'resource_limit'; If the value returned is not set to TRUE, this is a Finding.

Fix Text (F-26552r1_fix)
Enable resource limit checking on the database. From SQL*Plus: alter system set resource_limit = TRUE scope = both; The above SQL*Plus command will set the parameter to take effect immediately and permanently at next system startup.