This content has been marked as final. Show 2 replies
AFAIK, 9i does not support expiring database users on a specific date. Pl elaborate on how "user accounts are going to expire on month of APRIL i.e 04-APRIL-13" has been achieved
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 220.127.116.11.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?