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
本站僅提供存儲服務,所有內(nèi)容均由用戶發(fā)布,如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容,請
點擊舉報。