prev/ORACLE

특정사용자 lock풀기

WishDEV 2007. 1. 16. 11:01

SQL> select username ,account_status from dba_users;

USERNAME                   ACCOUNT_STATUS
----------------------- --------------------------------

SYSTEM                       LOCKED(TIMED)
SYS                             LOCKED(TIMED)


lock 을 풀어 준다.

SQL> alter user test account unlock;