Information
The FAILED_LOGIN_ATTEMPTS setting defines the number of consecutive failed login attempts allowed before a user's account is locked. While different profiles can have customized settings based on organizational needs, a minimum recommended value of 5 should be enforced.
Organizations may choose a higher value for specific use cases, such as application data source accounts, to prevent unnecessary lockouts while maintaining security. However, increasing this threshold should be carefully reviewed to ensure that the system's security posture is maintained and accounts are protected against unauthorized or brute-force login attempts.
Repeated failed login attempts may indicate the initiation of a brute-force attack. Therefore, this value should be configured based on the organization's security requirements, balancing account protection with operational needs.
Solution
Remediate this setting by executing the following SQL statement for each PROFILE returned by the audit procedure.
ALTER PROFILE <profile_name> LIMIT FAILED_LOGIN_ATTEMPTS 5;