Oracle: how to set user password unexpire? [duplicate]

Question

There is some construction

ALTER USER scott PASSWORD EXPIRE

But how can I similair set password to unexpired state?

Answer 1

If you create a user using a profile like this:

CREATE PROFILE my_profile LIMIT
       PASSWORD_LIFE_TIME 30;
ALTER USER scott PROFILE my_profile;

then you can change the password lifetime like this:

ALTER PROFILE my_profile LIMIT
  PASSWORD_LIFE_TIME UNLIMITED;

I hope that helps.