Re: passwords

In our last gripping episode "Namia" <namia_at_hotmail.com> wrote:
> 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
>

I fully understand this, however the original post did not mention the release number and I presumed that it would be at least Oracle 8. Hence my "solution". Had the original post mentioned that the database was Oracle 7.1 my answer would have been quite different.

> "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.
>
>

--
David Fitzjarrell
Oracle Certified DBA


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