Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Password Life Time and Password Grace time

718729Jan 26 2012 — edited Jan 27 2012
One of critical user process id will expire on 02FEB, I set the password grace time , Password reuse time as " UNLIMITED". Will the password expire on 02 FEB2012 ? Kindly give ur suggestion
================================================================


select LIMIT, RESOURCE_NAME from dba_profiles where RESOURCE_NAME
in ('PASSWORD_GRACE_TIME','PASSWORD_LIFE_TIME','PASSWORD_REUSE_MAX','PASSWORD_REUSE_TIME')
and PROFILE=(select profile from dba_users where username='ESBS');SQL> 2 3

LIMIT RESOURCE_NAME
---------------------------------------- --------------------------------
90 PASSWORD_LIFE_TIME
UNLIMITED PASSWORD_REUSE_TIME
UNLIMITED PASSWORD_REUSE_MAX
UNLIMITED PASSWORD_GRACE_TIME

SQL> select USERNAME,ACCOUNT_STATUS , EXPIRY_DATE from dba_users where username='ESBS_SEL';

USERNAME ACCOUNT_STATUS EXPIRY_DA
------------------------------ -------------------------------- ---------
ESBS OPEN 02-FEB-12
This post has been answered by AliD on Jan 26 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 24 2012
Added on Jan 26 2012
5 comments
8,248 views