Database users should not be locked

Database users should not be locked

1) view the default number of database locks

[SQL]

1. SQL>SetLinesize 2000
2. SQL>Select*FromDba_profilesWhereResource_nameLike 'Failed _ LOGIN_ATTEMPTS %';
4. PROFILE RESOURCE_NAME RESOURCE LIMIT
5. --------------------------------------------------------------------------------------------------------------
6. DEFAULTFAILED_LOGIN_ATTEMPTSPASSWORD10
7. MONITORING_PROFILE FAILED_LOGIN_ATTEMPTSPASSWORDUNLIMITED

We can see from the above that the database is locked after 10 retries

2) view the last locked time

[SQL]

1. SQL>SelectLOCK_DATE, usernameFromDba_usersWhereUsername ='Jscn';

If the value of LOCK_DATE is null, it indicates that it is not locked. If the value is not empty, it indicates that it is locked.

LOCK_DATE, username
-----------------------------------
13:36:10 JSCN

3) set the default logon times of the system.

[SQL]

1. SQL>AlterProfileDEFAULTLimit FAILED_LOGIN_ATTEMPTS 10;-- Retries 10 locks in a row
3. Profile altered.
5. SQL>AlterProfileDEFAULTLimit FAILED_LOGIN_ATTEMPTS UNLIMITED;-- Do not lock
7. Profile altered.

4) Unlock

[SQL]

1. SQL>Alter UserJscn account unlock;
3. UserAltered.