메뉴 건너뛰기

bysql.net

ORA-28000: the account is locked

2010.06.07 00:25

휘휘 조회 수:144804

일정횟수 이상 로그인 실패시 나타나는 오류


 - create profile 명령을 통해 지정

 - 10g의 scott 계정 처음 수행시 나타남



SQL> select username,account_status,lock_date from dba_users;

USERNAME                       ACCOUNT_STATUS                   LOCK_DATE
------------------------------ -------------------------------- ---------
MGMT_VIEW                      OPEN
SYS                            OPEN
SYSTEM                         OPEN
DBSNMP                         OPEN
SYSMAN                         OPEN
SCOTT                          LOCKED                           15-JAN-10



SQL> alter user scott account unlock;

User altered.

SQL>



SQL> select username,account_status,lock_date from dba_users;

USERNAME                       ACCOUNT_STATUS                   LOCK_DATE
------------------------------ -------------------------------- ---------
MGMT_VIEW                      OPEN
SYS                            OPEN
SYSTEM                         OPEN
DBSNMP                         OPEN
SYSMAN                         OPEN
SCOTT                          OPEN