Hi,
I have a user in DB for whom the Account_status is showing in "OPEN" state even though the expiry_date has passed way before. Please see below:

USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP EXTERNAL_NAME
BROWJ079 1018 5973FF44C894C986 OPEN 1/23/2012 10:58:24 AM RETEK_DATA TEMP 10/12/2009 2:03:10 PM SIMBA_NOT_USED DEFAULT_CONSUMER_GROUP


Following is the DBA_PROFILES setting:

USERNAME PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT
BROWJ079 SIMBA_NOT_USED COMPOSITE_LIMIT KERNEL DEFAULT
BROWJ079 SIMBA_NOT_USED SESSIONS_PER_USER KERNEL DEFAULT
BROWJ079 SIMBA_NOT_USED CPU_PER_SESSION KERNEL DEFAULT
BROWJ079 SIMBA_NOT_USED CPU_PER_CALL KERNEL DEFAULT
BROWJ079 SIMBA_NOT_USED LOGICAL_READS_PER_SESSION KERNEL DEFAULT
BROWJ079 SIMBA_NOT_USED LOGICAL_READS_PER_CALL KERNEL DEFAULT
BROWJ079 SIMBA_NOT_USED IDLE_TIME KERNEL DEFAULT
BROWJ079 SIMBA_NOT_USED CONNECT_TIME KERNEL DEFAULT
BROWJ079 SIMBA_NOT_USED PRIVATE_SGA KERNEL DEFAULT
BROWJ079 SIMBA_NOT_USED FAILED_LOGIN_ATTEMPTS PASSWORD 3
BROWJ079 SIMBA_NOT_USED PASSWORD_LIFE_TIME PASSWORD 90
BROWJ079 SIMBA_NOT_USED PASSWORD_REUSE_TIME PASSWORD 360
BROWJ079 SIMBA_NOT_USED PASSWORD_REUSE_MAX PASSWORD 5
BROWJ079 SIMBA_NOT_USED PASSWORD_VERIFY_FUNCTION PASSWORD WD_PASSWORD_VERIFICATION
BROWJ079 SIMBA_NOT_USED PASSWORD_LOCK_TIME PASSWORD UNLIMITED
BROWJ079 SIMBA_NOT_USED PASSWORD_GRACE_TIME PASSWORD 10


Kindly let me know why the ACCOUNT_STATUS is not showing to EXPIRED even though the EXPIRY_DATE is passed?

Thanks,
Saurabh

This is the expected behaviour. The account status is updated only when the user will attempt to connect to the database while the expiry date is updated more frequently( when the user gets created, when the associated profile is modified, when the user is altered, etc. ). If an user is not connecting to the database after the expiry date has passed then the ACCOUNT_STATUS will remain set to OPEN.

When this account is connecting to the database, the current date/time is compared with the value of EXPIRY_DATE. If EXPIRY_DATE is older than the current date/time then the system will check whether the PASSWORD_GRACE_TIME parameter is defined.  If it is set then the grace period is startedt,  the account status is updated to "EXPIRED(GRACE)" and the EXPIRY_DATE is updated to a date which shows when the the account will be locked out.