DO3696-ORACLE11 - The Oracle RESOURCE_LIMIT parameter should be set to TRUE - 'resource_limit = true'

Information

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.

Solution

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.

See Also

https://dl.dod.cyber.mil/wp-content/uploads/stigs/zip/U_Oracle_Database_11g_Y21M10_STIG.zip

Item Details

References: CAT|II, Rule-ID|SV-24942r2_rule, STIG-ID|DO3696-ORACLE11, Vuln-ID|V-2593

Plugin: OracleDB

Control ID: fdd56a3cb78c2f5374463a834a8ed2efb8058da3a770c274d2e99ca5a946018a