The "default" profile does this normally. Create a profile that has the password never expiring. Don't forget to add the procedure for password completity.

-----Original Message-----
From: Sikyala Raquel [USA] [mailto:oracledba-ezmlmshield-x40769863.[Email address protected]
Sent: Tuesday, March 04, 2008 12:41 PM
To: LazyDBA Discussion
Subject: How to get rid of expiration on password

How can I change a database user account so that the users password never expires?

What is the syntax?

Thanks!


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page