oracle解除對scott/tiger用戶的鎖定

    oracle 解除對scott/tiger用戶的鎖定
    1、查證目前系統(tǒng)對于scott用戶的狀態(tài)：
    select * from dba_users where upper(username)='scott';
    account_status:expired & locked
    2、解除對于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)過期，請重新輸入新的密碼：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