Oracle Password Expiration
Can someone explain this to me??
I have a profile that all my users use. With regards to password expiration, I have their password expire in 80 days with a 10 day grace period.
First question: Does this mean that when they reach 80 days, they will start getting the message [at every logon] that their "password will expiring in X days..." ?
OR do they start getting that message when they have reached the 70th day?
When I look at the account_status in dba_users, I see some users have a status of "OPEN", while the date on their expiry_date field has already passed. Shouldn't it say EXPIRED? I see others with "EXPIRED(GRACE)" status - I am assume that these are the users who are in their grace period.
Can someone give me an explanation on how Oracle actually does this??