Re: passwords

In our last gripping episode chartek_at_my-deja.com wrote:
> How would I implement users having to change their passwords every X
> number of days?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

First, create a general user profile and assign to it the password limiting parameters you want implemented:

create profile limit_profile
limit failed_login_attempts 5

password_life_time 90
password_reuse_max 3
password_reuse_time unlimited;

Now alter the users to set their profile to 'limit_profile':

alter user elmo
profile limit_profile;

Do this for each user you wish to password restrict. Now the user cannot have any more than 5 failed login attempts, will have a 90 day password lifetime and cannot reuse the last 3 passwords.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.