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)過(guò)期，請(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