Password Life Time and Password Grace time
718729Jan 26 2012 — edited Jan 27 2012One 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