When a user fails to log in continuously for too many times, Oracle will lock the user, “failed”_ LOGIN_ Attempts “is used to set the maximum number of times. If the value is exceeded, the account will be locked.
The following methods can be used to limit the number of failed logins:
1. Enter the following command to view “failed”_ LOGIN_ Attempts “value:
SQL> select * from dba_profiles s where s.profile=’DEFAULT’ and resource_name=’FAILED_LOGIN_ATTEMPTS’;
2. Enter the following command to modify “failed”_ LOGIN_ The value of attempts is unlimited:
SQL>alter profile default limit failed_login_attempts unlimited;
3. Review “failed”_ LOGIN_ Attempts “value:
In this way, no matter how many times a user fails to log in continuously, the user account will not be locked.
It is not very simple, need to cancel the user continuous login failure limit of friends, according to these three steps to achieve it!