|
À¯ÀúÀÇ »óŸ¦ È®ÀÎÇÏ´Â SQLÀÔ´Ï´Ù.
SELECT USERNAME, ACCOUNT_STATUS, LOCK_DATE, EXPIRY_DATE, PROFILE
FROM DBA_USERS
where ACCOUNT_STATUS != 'OPEN';
USERNAME ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE PROFILE
---------- ----------------- ------------------- ------------------- --------
OUTLN EXPIRED & LOCKED 2012/01/27 17:12:07 2012/01/27 17:12:07 DEFAULT
DIOFTP EXPIRED 2012/02/08 12:03:54 DEFAULT
PUSER LOCKED 2012/02/08 12:03:54 DEFAULT
WOONG EXPIRED(GRACE) 2012/05/18 12:49:01 DEFAULT
DEFAULT ProfileÀ» ¾²´Â À¯ÀúÁß¿¡ ¸î¸î Á¤»óÀûÀÌÁö ¾ÊÀº »óȲÀ¸·Î º¸À̳׿ä.
ÇØ´ç ÇÁ·ÎÆÄÀÏÀ» ¸ÕÀú È®ÀÎÇغ¾´Ï´Ù.
SELECT *
FROM DBA_PROFILES
WHERE PROFILE = 'DEFAULT'
AND RESOURCE_TYPE LIKE 'PASSWORD';
PROFILE RESOURCE_NAME RESOURCE LIMIT
-------- ------------------------- -------- ----------------
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 5
DEFAULT PASSWORD_LIFE_TIME PASSWORD 90
DEFAULT PASSWORD_REUSE_TIME PASSWORD 1440
DEFAULT PASSWORD_REUSE_MAX PASSWORD 10
DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD VERIFY_FUNCTION
DEFAULT PASSWORD_LOCK_TIME PASSWORD 90
DEFAULT PASSWORD_GRACE_TIME PASSWORD 7
Æнº¿öµå¿Í °ü·ÃµÈ ¸®¼Ò½º¸¦ È®ÀÎÇغ¸¸é ´ÙÀ½°ú °°½À´Ï´Ù.
FAILED_LOGIN_ATTEMPTS
: ·Î±×ÀÎÀ» ½ÇÆÐÇßÀ» ¶§ ·Î±×ÀÎÀÌ Á¦ÇѵǴ Ƚ¼ö. (À§ ¼³Á¤¿¡¼´Â ´Ù¼¸¹øÀÌ µÇ°Ú³×¿ä.)
PASSWORD_LIFE_TIME
: ¾ÏÈ£¸¦ º¯°æÇؾ߸¸ ÇÏ´Â Àϼö¸¦ ÀǹÌ. (¸¶Âù°¡Áö·Î 90Àϵ¿¾È »ç¿ë°¡´ÉÇϰڳ׿ä.)
PASSWORD_LOCK_TIME
: ¾ÏÈ£ ¿ÀÀÔ·ÂÀ¸·Î ·Î±×ÀÎ ½ÇÆнà ÀϽõ¿¾È ¶ôÀ» °É ½Ã°£À» ÀǹÌ.(1ºÐ(1/(24*60))µ¿¾È Àá±é´Ï´Ù.)
PASSWORD_GRACE_TIME
: ±âÁ¸¿¡ »ç¿ëÇß´ø ¾ÏÈ£¸¦ ´Ù½Ã »ç¿ëÇϱâ À§ÇØ °æ°ú µÇ¾î¾ßÇÏ´Â ½Ã°£À» ÀǹÌ.
PASSWORD_REUSE_TIME
: ±âÁ¸¿¡ »ç¿ëÇß´ø ¾ÏÈ£¸¦ ¹Ù·Î ´Ù½Ã »ç¿ëÇÏÁö ¸øÇϵµ·Ï ¸î°³ÀÇ ¾ÏÈ£¸¦ ÀçÀÔ·ÂÇÏÁö ¸øÇÏ°Ô ÇÑ´Ù.
PASSWORD_REUSE_MAX
: ¾ÏÈ£ º¯°æ¾È³» ¸Þ¼¼Áö¸¦ Ãâ·ÂÇϱ⠽ÃÀÛÇÒ -Day¸¦ ÀǹÌÇϸç ÀÌ ¼³Á¤À¸·Î ÀÎÇØ ORA-28002 µ¿ÀÛ.
PASSWORD_VERIFY_FUNCTION
: ¾ÏÈ£ º¹À⼺ ¿©ºÎ¸¦ ¼³Á¤ ÇÒ ¼ö ÀÖÀ½.
ÃÖÃÊ ¼³Ä¡ ½Ã °¢ ȸ»ç¿¡¼ Á¤ÇÑ º¸¾È±ÔÁ¤¿¡ ¸Â°Ô ¾Æ·¡Ã³·³ PROFILEÀ» Á¶Á¤ÇÑ ÈÄ Profile¿¡ ´ëÇÑ LimitÀ» ÇØÁ¦ÇÏ°Ô µÇ¸é Expired¸¦ ¸¸³ªº¸Áö ¸øÇÏ°ÚÁö¿ä. °£È¤ ÀÌ ºÎºÐÀ» °£°úÇÏ°í EXPIREDµÇ´Â °æ¿ì°¡ ¹ß»ýÇÕ´Ï´Ù. ¸ÇÀ§ÀÇ ¿¹Ã³·³¿ä.
±×·± °æ¿ì ´ÙÀ½ ÀýÂ÷·Î ó¸®ÇÏ°Ô µË´Ï´Ù.
1. ÇÁ·ÎÆÄÀÏÀ» ¸ÕÀú º¯°æÇÕ´Ï´Ù.
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED
PASSWORD_GRACE_TIME UNLIMITED;
2. LOCKÀ¸·Î »óÅ°¡ º¯Çß´Ù¸é
ALTER USER username ACCOUNT UNLOCK;
3. ÀÌ¹Ì ¸¸±â(EXPIRED)³ª ¸¸±âµµ·¡(EXPIRED(GRACE))°¡ µÈ °æ¿ì OPEN»óÅ·Πº¯°æÇϱâ À§Çؼ´Â Æнº¿öµåº¯°æÀÌ ºÒ°¡ÇÇÇÕ´Ï´Ù.
¾ÏÈ£¸¦ ¸ð¸¥´Ù¸é..±ÇÇѺи®·Î DBA°¡ ¸ðµç ¾ÏÈ£¸¦ ¾ËÁö ¸øÇÏ´Â ½Ã´ëÁÒ? ¶Ç, DBA±ÇÇÑÀ» °³¹ßÀÚ¿¡°Ô ÁÙ ¼öµµ ¾ø½À´Ï´Ù.
ÀÌ·± »óȲ¿¡¼..
3-1 sys.USER$Å×ÀÌºí¿¡¼ ¾ÏÈ£ÈµÈ Æнº¿öµå¸¦ ±¸ÇÕ´Ï´Ù.
SELECT PASSWORD
FROM SYS.USER$
WHERE NAME = 'username';
3-2 ±×¸®°í identified by value±¸¹®À» ÀÌ¿ëÇÏ¿© Æнº¿öµå¸¦ µ¡¾º¿ó´Ï´Ù.
ALTER USER IDENTIFIED BY VALUE 'À§¿¡¼ ±¸ÇÑ ¾ÏÈ£ÈµÈ Æнº¿öµå'
|