Oracle解除對(duì)SCOTT/TIGER用戶的鎖定

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