{"id":660,"date":"2015-11-20T01:47:25","date_gmt":"2015-11-20T01:47:25","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=660"},"modified":"2015-11-20T01:47:25","modified_gmt":"2015-11-20T01:47:25","slug":"user%ec%9d%98-profile-%ec%84%a4%ec%a0%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=660","title":{"rendered":"User\uc758 Profile \uc124\uc815"},"content":{"rendered":"

\ud754<\/SPAN>\ud788<\/SPAN> <\/SPAN>\uacf5\uacf5\uae30\uad00\uc774\ub098<\/SPAN> <\/SPAN>\uae08\uc735\uad8c\uc5d0\uc11c\ub294<\/SPAN> <\/SPAN>\ud328\uc2a4\uc6cc\ub4dc\uc758 \uc0ac\uc6a9\uae30\uac04 \ubc0f \ubcf5\uc7a1\ub3c4\ub97c \uc815\ucc45\uc5d0 \ub9de\ub3c4\ub85d \uc124\uc815 \ud569\ub2c8\ub2e4<\/SPAN>.<\/SPAN><\/P>
\n

User <\/SPAN>\ub9c8\ub2e4<\/SPAN> Profile <\/SPAN>\uc774<\/SPAN> <\/SPAN>\uc124\uc815<\/SPAN> <\/SPAN>\ub418\uc5b4<\/SPAN> <\/SPAN>\uc788\ub294\ub370<\/SPAN>, <\/SPAN>\uae30\ubcf8\uc801\uc73c\ub85c\ub294<\/SPAN> Default Profile <\/SPAN>\ub85c<\/SPAN> <\/SPAN>\uc124\uc815<\/SPAN> <\/SPAN>\ub418\uc5b4<\/SPAN> <\/SPAN>\uc788\uc73c\uba70<\/SPAN><\/P>
\n

\uac01\uac01<\/SPAN> User <\/SPAN>\ub9c8\ub2e4<\/SPAN> Profile <\/SPAN>\uc744<\/SPAN> <\/SPAN>\uc124\uc815<\/SPAN> <\/SPAN>\ud574\uc904<\/SPAN> <\/SPAN>\uc218<\/SPAN> <\/SPAN>\uc788\uc2b5\ub2c8\ub2e4<\/SPAN>.<\/SPAN><\/P>
\n

 <\/SPAN><\/P>
\n

%<\/SPAN> User \uc758 Profile \ubc0f Password Life_Time \ud655\uc778<\/SPAN><\/P>
\n

SQL) col ACCOUNT_STATUS for a18<\/SPAN><\/P>
\n

SQL) col LIMIT for a15<\/SPAN><\/P>
\n

SQL) <\/SPAN>col LAST_PWD_CHG_DT for a20<\/SPAN><\/P>
\n

SQL) <\/SPAN>col EXPIRED_PWD_DT for a20<\/SPAN><\/P>
\n

SQL) select u.USERNAME,u.ACCOUNT_STATUS,u.LOCK_DATE,u.EXPIRY_DATE,u.CREATED,u1.ptime as “LAST_PWD_CHG_DT”, P.LIMIT ,<\/SPAN><\/P>
\n

 <\/SPAN>decode ( P.LIMIT , ‘UNLIMITED’,’9999\/12\/31′ , ‘DEFAULT’, to_char(u1.ptime+180,’YYYY\/MM\/DD’ ) , to_char(u1.ptime+to_number(P.LIMIT),’YYYY\/MM\/DD’ )<\/SPAN>  <\/SPAN>) as “EXPIRED_PWD_DT”,u.profile<\/SPAN><\/P>
\n

 <\/SPAN>from dba_users u,sys.user$ u1 , dba_profiles p<\/SPAN><\/P>
\n

 <\/SPAN>where u.username=u1.name<\/SPAN><\/P>
\n

and u.profile = p.profile<\/SPAN><\/P>
\n

and p.RESOURCE_NAME=’PASSWORD_LIFE_TIME’<\/SPAN><\/P>
\n

\/<\/SPAN><\/P>
\n

 <\/SPAN><\/P>
\n

%<\/SPAN> Default Profile \uc5d0 \uc124\uc815\ub418\uc5b4 \uc788\ub294 \uac12 \ud655\uc778.<\/SPAN><\/P>
\n

SQL) <\/SPAN>select * from DBA_PROFILES where profile=’DEFAULT’;<\/SPAN><\/P>
\n

 <\/SPAN><\/P>
\n

% Profile <\/SPAN>\uc0dd\uc131\ud558\uae30<\/SPAN><\/P>
\n

SQL) create profile test limit <\/SPAN><\/P>
\n

       <\/SPAN>password_life_time 30<\/SPAN><\/P>
\n

       <\/SPAN><\/SPAN>password_reuse_time 30<\/SPAN><\/P>
\n

       <\/SPAN><\/SPAN>password_grace_time 5;<\/SPAN><\/P>
\n

 <\/SPAN><\/P>
\n

% Profile <\/SPAN>\uc0dd\uc131\uc2dc<\/SPAN> <\/SPAN>\ub530\ub85c<\/SPAN> <\/SPAN>\uc9c0\uc815\uc744<\/SPAN> <\/SPAN>\uc548\ud574\uc8fc\uba74<\/SPAN> Default Profile <\/SPAN>\uc124\uc815\uc744<\/SPAN> <\/SPAN>\ub530\ub77c<\/SPAN> <\/SPAN>\uac00\uac8c<\/SPAN> <\/SPAN>\ub429\ub2c8\ub2e4<\/SPAN>.<\/SPAN><\/P>
\n

select * from DBA_PROFILES where profile=’<\/SPAN>TEST<\/SPAN>‘;<\/SPAN><\/P>
\n

————————————————————————————————<\/SPAN><\/P>
\n

TEST                        <\/SPAN>       <\/SPAN>FAILED_LOGIN_ATTEMPTS                PASSWORD DEFAULT<\/SPAN><\/P>
\n

TEST                        <\/SPAN>       <\/SPAN>PASSWORD_LIFE_TIME                PASSWORD 30<\/SPAN><\/P>
\n

TEST                        <\/SPAN>       <\/SPAN>PASSWORD_REUSE_TIME                PASSWORD 30<\/SPAN><\/P>
\n

TEST                        <\/SPAN>       <\/SPAN>PASSWORD_REUSE_MAX                PASSWORD DEFAULT<\/SPAN><\/P>
\n

TEST                        <\/SPAN>       <\/SPAN>PASSWORD_VERIFY_FUNCTION         PASSWORD DEFAULT<\/SPAN><\/P>
\n

TEST                        <\/SPAN>       <\/SPAN>PASSWORD_LOCK_TIME                PASSWORD DEFAULT<\/SPAN><\/P>
\n

TEST                        <\/SPAN>       <\/SPAN>PASSWORD_GRACE_TIME                PASSWORD DEFAULT<\/SPAN><\/P>
\n

 <\/SPAN><\/P>
\n

% User<\/SPAN>\uc5d0<\/SPAN> Profile <\/SPAN>\uc801\uc6a9<\/SPAN> <\/SPAN>\uc2dc\ud0a4\ub294<\/SPAN> <\/SPAN>\ubc29\ubc95<\/SPAN><\/P>
\n