oracle使用者解鎖

1.    1.查詢允許使用者密碼連續輸入錯誤次數，超過次數就會鎖定該使用者

SQL> select * from dba_profiles where profile='DEFAULT' and resource_type='PASSWORD';

PROFILE      RESOURCE_NAME                       RESOURCE       LIMIT

--------------  ----------------------------------        --------------     ---------------

DEFAULT    FAILED_LOGIN_ATTEMPTS      PASSWORD     10

DEFAULT     PASSWORD_LIFE_TIME                PASSWORD      180

DEFAULT     PASSWORD_REUSE_TIME             PASSWORD      UNLIMITED

DEFAULT     PASSWORD_REUSE_MAX              PASSWORD      UNLIMITED

DEFAULT     PASSWORD_VERIFY_FUNCTION    PASSWORD      NULL

DEFAULT     PASSWORD_LOCK_TIME               PASSWORD      1

DEFAULT     PASSWORD_GRACE_TIME             PASSWORD      7

 

2.    2.查詢使用者鎖定狀態

SQL> select u.username,u.account_status,t.lcount,u.profile from dba_users u,user$ t where t.name=u.username and t.name='SCOTT';

USERNAME     ACCOUNT_STATUS     LCOUNT     PROFILE

--------------    ------------------------     -----------    ------------------------

SCOTT            OPEN                         1              DEFAULT

 

3.    3.嘗試10次錯誤密碼輸入

SQL> conn scott/12

ERROR:

ORA-28000: the account is locked

Warning: You are no longer connected to ORACLE.

 

4.    4.查詢使用者鎖定狀態

SQL> select u.username,u.account_status,t.lcount,u.profile from dba_users u,user$ t where t.name=u.username and t.name='SCOTT';

USERNAME   ACCOUNT_STATUS  LCOUNT   PROFILE

---------------- ------------------------  ----------- ------------

SCOTT          LOCKED(TIMED)    10            DEFAULT

 

5.    5.使用者解鎖

SQL> alter user scott account unlock;

User altered.

注：如果忘記密碼重新設定

SQL>  alter user scott identified by tiger ;

User altered.

 

6.    6.查詢使用者解鎖狀態

SQL> select u.username,u.account_status,t.lcount,u.profile from dba_users u,user$ t where t.name=u.username and t.name='SCOTT';

USERNAME     ACCOUNT_STATUS   LCOUNT    PROFILE

----------------- ------------------------  ------------  ------------

SCOTT            OPEN                       0              DEFAULT

 

7.    7.解除密碼錯誤輸入次數限制

SQL> alter profile default limit FAILED_LOGIN_ATTEMPTS unlimited;

Profile altered.

 

8.    8.查詢使用者密碼錯誤輸入次數限制

SQL> select * from dba_profiles where profile='DEFAULT' and resource_type='PASSWORD';

PROFILE     RESOURCE_NAME                      RESOURCE      LIMIT

-----------     ----------------------------------       ---------------   -------------

DEFAULT   FAILED_LOGIN_ATTEMPTS      PASSWORD    UNLIMITED

DEFAULT     PASSWORD_LIFE_TIME              PASSWORD    180

DEFAULT     PASSWORD_REUSE_TIME           PASSWORD    UNLIMITED

DEFAULT     PASSWORD_REUSE_MAX            PASSWORD    UNLIMITED

DEFAULT     PASSWORD_VERIFY_FUNCTION  PASSWORD    NULL

DEFAULT     PASSWORD_LOCK_TIME             PASSWORD    1

DEFAULT     PASSWORD_GRACE_TIME           PASSWORD    7


            --------------end------------------
                
                        DBA_建瑾
                        2014.9.7