The Oracle RESOURCE_LIMIT parameter should be set to TRUE.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-2593	DO3696-ORACLE11	SV-24942r2_rule		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 11g Instance STIG	2017-06-29

Details

Check Text ( C-29487r2_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-26553r1_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.