문서의 이전 판입니다!
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;
CREATE PROFILE "SERVICE_PROFILE" LIMIT CPU_PER_SESSION DEFAULT CPU_PER_CALL DEFAULT CONNECT_TIME UNLIMITED IDLE_TIME DEFAULT SESSIONS_PER_USER UNLIMITED LOGICAL_READS_PER_SESSION DEFAULT LOGICAL_READS_PER_CALL DEFAULT PRIVATE_SGA DEFAULT COMPOSITE_LIMIT DEFAULT PASSWORD_LIFE_TIME DEFAULT PASSWORD_GRACE_TIME DEFAULT PASSWORD_REUSE_MAX DEFAULT PASSWORD_REUSE_TIME DEFAULT PASSWORD_LOCK_TIME DEFAULT FAILED_LOGIN_ATTEMPTS UNLIMITED PASSWORD_VERIFY_FUNCTION DEFAULT
ALTER USER "BEFLYDBA" PROFILE "SERVICE_PROFILE"