Meenakshy singh wrote:You can't set a specific expiration date, only a password lifetime. But given the target date ... 31 dec 2099 .. isn't even within the life expectancy of anyone on this board, I'd expect the person who stated that requirement really wants passwords to never expire. So, password_lifetime=unlimited.
My oracle version is Oracle9i Enterprise Edition Release 184.108.40.206.0 - 64bit on AIX machine.
My client requirement is to set the users profile expiry_date to *31/12/2099* .
The user accounts are going to expire on month of APRIL i.e *04-APRIL-13* but now my clients want to extend user expiry date *04-APRIL-13* to *31/12/2099*
How to set this expiry date to *31/12/2099* , any idea?