USER 락(LOCK) 해제 쿼리

- 특정 사용자의 LOCK 계정 상태를 확인하여 풀어주는 것

SQL> select username, account_status, to_char(lock_date,'YYYYMMDDHH24MI') LOCK_DATE FROM DBA_USERS WHERE USERNAME='SCOTT';

USERNAME                       ACCOUNT_STATUS                   LOCK_DATE
------------------------------ -------------------------------- ------------
SCOTT                          LOCKED                           201008142251

SQL> alter user scott account unlock;

User altered.

SQL> select username, account_status, to_char(lock_date,'YYYYMMDDHH24MI') LOCK_DATE FROM DBA_USERS WHERE USERNAME='SCOTT';

USERNAME                       ACCOUNT_STATUS                   LOCK_DATE
------------------------------ -------------------------------- ------------
SCOTT                          OPEN