Oracle: how to set user password unexpire?

Question

There is some construction ``` ALTER USER scott PASSWORD EXPIRE ``` But how can I similair set password to unexpired state?

Accepted Answer

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.

Solution