Password aging without expiry [message #583871] |
Mon, 06 May 2013 06:42 |
|
rashmibs
Messages: 4 Registered: May 2013
|
Junior Member |
|
|
Hi All,
We have a requirement that the password of users never expire. But the user is notified when the password has not been changed for a long time. For example: If the user has not changed his password in 100days, he is to be notified that the password is old and he should consider changing it.
Is this possible directly through the password policy configurations? Or will it have to be handled using a separate procedure?
|
|
|
|
|
Re: Password aging without expiry [message #583874 is a reply to message #583873] |
Mon, 06 May 2013 06:58 |
|
Michel Cadot
Messages: 68693 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
With a password_grace_time to unlimited it will actually not expire but each time the user connect he will receive a message saying his password is in grace period and so it is older than 100 days.
I think this is the best solution.
Regards
Michel
[Updated on: Mon, 06 May 2013 06:59] Report message to a moderator
|
|
|
Re: Password aging without expiry [message #583878 is a reply to message #583874] |
Mon, 06 May 2013 07:29 |
John Watson
Messages: 8951 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Exactly. See this, rashmibs:orcl>
orcl> alter user jw password expire
2 ;
User altered.
orcl>
orcl> conn jw/jw
ERROR:
ORA-28001: the password has expired
Changing password for jw
New password: Your software will have to handle the ora-28001 appropriately. SQL*Plus throws you straight into a prompt to change the password but it sounds as though you want only a message.
|
|
|
|
|
|
|
|