現狀檢查
SELECT * FROM DBA_USERS WHERE USERNAME = 'SCOTT';
-- ACCOUNT_STATUS: EXPIRED & LOCKED
解鎖步驟
- 以 SYSDBA 登入:
CONN SYS/PASSWORD@TNS AS SYSDBA
- 解鎖帳號:
ALTER USER SCOTT ACCOUNT UNLOCK;
- 驗證狀態:
SELECT * FROM DBA_USERS WHERE USERNAME = 'SCOTT';
-- ACCOUNT_STATUS: EXPIRED
- 以 SCOTT 登入(會提示密碼過期,重設為 TIGER):
CONN SCOTT/TIGER@TNS
-- 提示密碼過期,輸入新密碼 TIGER
CONN SCOTT/TIGER@TNS -- 成功
- 最終狀態:
SELECT * FROM DBA_USERS WHERE USERNAME = 'SCOTT';
-- ACCOUNT_STATUS: OPEN
補充說明
ACCOUNT UNLOCK 僅解鎖,密碼仍過期;首次登入會強制修改密碼。
- 若需同步解鎖並重設密碼:
ALTER USER SCOTT IDENTIFIED BY TIGER ACCOUNT UNLOCK;
- 11g+ 預設密碼驗證函數可能要求複雜度,測試環境可關閉
PASSWORD_VERIFY_FUNCTION。