일정횟수 이상 로그인 실패시 나타나는 오류
- 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