문서의 이전 판입니다!
SELECT USERNAME,ACCOUNT_STATUS,TO_CHAR(LOCK_DATE,'YYYY.MM.DD HH24:MI') LOCK_DATE FROM DBA_USERS;
USERNAME ACCOUNT_STATUS LOCK_DATE ------------------------------ -------------------------------- ---------------- SCOTT OPEN CTXSYS EXPIRED & LOCKED 2008.09.26 11:09 TESTDBA LOCKED(TIMED) 2008.10.15 10:56 SCOTT EXPIRED & LOCKED 2008.09.26 11:09
ALTER USER SCOTT ACCOUNT UNLOCK;
SELECT USERNAME,ACCOUNT_STATUS,TO_CHAR(LOCK_DATE,'YYYY.MM.DD HH24:MI') LOCK_DATE FROM DBA_USERS WHERE USERNAME='SCOTT';
USERNAME ACCOUNT_STATUS LOCK_DATE ------------------------------ -------------------------------- ---------------- SCOTT EXPIRED
ALTER USER SCOTT IDENTIFIED BY TIGER;
USERNAME ACCOUNT_STATUS LOCK_DATE ------------------------------ -------------------------------- ---------------- SCOTT OPEN
ALTER USER user_id ACCOUNT UNLOCK;
SET LINES 200 SET pages 200 SELECT U.USERNAME,P.PROFILE, P.RESOURCE_NAME, P.LIMIT FROM DBA_USERS U, DBA_PROFILES P WHERE P.PROFILE=U.PROFILE AND USERNAME='SCOTT';
set lines 200 set pages 200
SELECT U.USERNAME,P.PROFILE, P.RESOURCE_NAME, P.LIMIT FROM DBA_USERS U, DBA_PROFILES P WHERE P.PROFILE=U.PROFILE AND RESOURCE_NAME='FAILED_LOGIN_ATTEMPTS'; </code>
ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS 5;