Oracle 解除對SCOTT/TIGER用戶的鎖定
    1、查證目前系統(tǒng)對于SCOTT用戶的狀態(tài)：
    select * from dba_users where upper(username)='SCOTT';
    ACCOUNT_STATUS:EXPIRED & LOCKED
    2、解除對于SCOTT用戶的鎖定：
    conn as sysdba;
    alter user scott account unlock;
    select * from dba_users where upper(username)='SCOTT';
    ACCOUNT_STATUS:EXPIRED
    3、連接SCOTT用戶：
    conn ;提示該用戶已經(jīng)過期，請重新輸入新的密碼：tiger
    conn ;此次可以正常連接此用戶。
    4、查看SCOTT用戶的狀態(tài)：
    conn as sysdba;
    select * from dba_users where upper(username)='SCOTT';
    ACCOUNT_STATUS:OPEN