Oracle password attempts and oracle attempts

Oracle password attempts and oracle attempts

Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.

Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/42417761

Lab Environment

Operating System	WIN7 64bit
Database	Oracle 11G R2 (11.2.0.1.0)

Premise: when a user attempts to log on with a wrong password, the user will be locked.

Lab:

When you use PL/SQL Developer to simulate multiple password input errors for a scott user, a ORA-28000 error: User locked is prompted, as shown below:

 

Solution:

You can use the dba user to unlock it as follows:

SQL> alter user scott account unlock;

Log On again as follows:

Settings:

1. view the FAILED_LOGIN_ATTEMPTS Value

SQL> select * from dba_profiles;

2. Modify the default number of times

SQL> alterprofiledefalimitlimitfailed_login_attempts100;

-- Change the number of failed attempts to 100

3. The default modification is unlimited.

SQL> alter profile default limit failed_login_attempts unlimited;

-- Change the password attempt error to an unlimited number of times

 

Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.

Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/42417761