3.8 Ensure 'INACTIVE_ACCOUNT_TIME' Is Less than or Equal to '120'

Information

The INACTIVE_ACCOUNT_TIME parameter in Oracle specifies the number of days an account can remain inactive before it is automatically locked. This setting helps mitigate security risks by reducing the exposure of unused accounts, which could be exploited for unauthorized access.

Inactive user accounts pose security risks as they can be potentially targeted by the attackers for unauthorized access. Setting a reasonable threshold for inactivity helps enforce security best practices by ensuring that unused accounts are locked before they can be potentially targeted for unauthorized access. A value of 120 days or less strikes a balance between security and operational flexibility.

Solution

Remediate this setting by executing the following SQL statement for each PROFILE returned by the audit procedure.

ALTER PROFILE DEFAULT LIMIT INACTIVE_ACCOUNT_TIME 120

Impact:

If an account is locked due to inactivity, administrators may need to manually unlock it when required. Organizations should communicate this policy to users to avoid disruptions.

See Also

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

Item Details

Category: ACCESS CONTROL

References: 800-53|AC-2(3), CSCv7|16.9

Plugin: OracleDB

Control ID: ea25b0c69ca2dfb6dfd13e605b329ec0f9176036e2a00add26c2677999578865