ERROR-ORA-28000: the account is locked

CODEDRAGON Development/Database

반응형

   

오류 메시지

ORA-28000: the account is locked

   

   

lock 걸린 User 찾기

SELECT username, account_status, to_char(lock_date,'yy/mm/dd hh24:mi') lock_date, profile FROM dba_users;

   

   

Lock 풀기 (유저가 user02 일 경우)

alter user user02 account unlock;