| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Password expiry
Hi Linda,
Linda Harte wrote:
>
> How do you set up a user in Oracle with a password that
> expires after a certain period of time or after a certain
> number of days.
--
ou have to do it through the profile.
When you create a user, you assign a profile to the user. And in the profile, there is a PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME parameters.
You have to alter the profile first. The PASSWORD_LIFE_TIME is set to unlimited in default profile. You might want to create a NEW profile.
create profile new_profile limit
PASSWORD_LIFE_TIME 30;
or
alter profile default limit
PASSWORD_LIFE_TIME 30;
ie 30 days. You can also set PASSWROD_GRACE_TIME(let said 5), which mean
that if the password is not change within 5 days after the password has
expired, the user will not be able to log in.
Hope that answer your question.
 |
 |