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!

Oracle Password Expiry + Grace (controlling when an account_status becomes grace)

User_UAEUZAug 23 2015 — edited Aug 24 2015

Hi all,

I notice that

a) account status is still open even after password expiry date

b) grace period is triggered only upon login after expiry which means that literally , i am given 1 day of grace period after my last login attempt and my last login attempt can be many days after my password expiry and i am still able to login for the grace period set.

Current Date is 24th Aug 15

-- my grace period is set as 1.

Account_Status       Expiry_Date

===========================

Open                      22th Aug 15

q1) is the above behavior normal ? or there is something wrong with my settings ?

q2) how do i set a grace period in which it is calculated base on the expiry_date and not when the user last login ?

Right now, after i login on the 24th, the expiry_Date is as below

Account_Status       Expiry_Date

===========================

Expired(Grace)         25th Aug 15

which is current_Date + 1.

How do i set it as expiry_Date + 1 which is 23rd Aug 15?

Meaning that, on the 22thAug15, the password will expire, user is still allow to login on the 23th if they want, but after 23th, they will not be able to login any further (password has expired)

Regards,

Noob

This post has been answered by Franck Pachot on Aug 23 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2015
Added on Aug 23 2015
5 comments
6,509 views