Alter that user and assign him to a different profile that has been set the PASSWORD_LIFE_TIME to UNLIMITED. Or alter his profile to set its PASSWORD_LIFE_TIME to UNLIMITED.

Looking at ALTER/CREATE PROFILE and ALTER USER command will give you the exact needed syntax.

BTW, it is very hard to find any correspondence with your signiture (OCP 8/8i !!!) and this kind of questions..... Yes, I'm a little annoying, I know, but I couldn't help myself not to mention this.

[Edited by jmodic on 07-04-2002 at 08:52 AM]