2.3.14 Ensure 'RESOURCE_LIMIT' Is Set To 'TRUE'

Warning! Audit Deprecated

This audit has been deprecated and will be removed in a future update.

View Next Audit Version

Information

RESOURCE_LIMIT determines whether resource limits are enforced in database profiles. This setting should have a value of TRUE

If RESOURCE_LIMIT is set to FALSE none of the system resource limits that are set in any database profiles are enforced. If RESOURCE_LIMIT is set to TRUE the limits set in database profiles are enforced.

Solution

To remediate this setting, execute the following SQL statement.

ALTER SYSTEM SET RESOURCE_LIMIT = TRUE SCOPE = BOTH;

See Also

https://workbench.cisecurity.org/benchmarks/16474