Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: passwords
Well I belwive that this is not supported by Oracle version 7 and is covered by Oracle 8....as oracle * has all these options which are not there in Oracle 7.XXX
Cheers
Namia
"David Fitzjarrell" <oratune_at_aol.com> wrote in message
news:8upj4o$f71$1_at_nnrp1.deja.com...
> 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.
Received on Mon Nov 13 2000 - 22:53:37 CST