Changes are coming to https://stigviewer.com.
Take our survey to help us understand your usage and how we can better serve you in the future.
Take Survey
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 | 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 11g Instance STIG | 2015-03-26 |
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. |