Restrictions on oracle user logon failures
"FAILED_LOGIN_ATTEMPTS" is used to configure the maximum number of consecutive password input errors. If this value is exceeded, the account is locked. 1. Run the following command to query the value of "FAILED_LOGIN_ATTEMPTS. SQL> select * from dba_profiles s where s. profile = 'default' and resource_name = 'failed _ LOGIN_ATTEMPTS '; if the result is as follows, "FAILED_LOGIN_ATTEMPTS" is configured for 10 times. PROFILE RESOURCE_NAME resource limit default FAILED_LOGIN_ATTEMPTS PASSWORD 10 2. Run the following command to change the value of "FAILED_LOGIN_ATTEMPTS" to "UNLIMITED ". SQL> alter profile default limit failed_login_attempts unlimited; 3. Run the following command again to view the value of "FAILED_LOGIN_ATTEMPTS. SQL> select * from dba_profiles s where s. profile = 'default' and resource_name = 'failed _ LOGIN_ATTEMPTS '; if the result is as follows, the "FAILED_LOGIN_ATTEMPTS" configuration is unrestricted. PROFILE RESOURCE_NAME resource limit default FAILED_LOGIN_ATTEMPTS password unlimited if a user has been locked, log on to the database as a system user and run the following command to unlock the locked account. SQL> alter user msgbox identified by password account unlock; in the preceding command, msgbox indicates the locked user name, and password indicates the password of the locked user. Author: wangliya110