Re: Where are FAILED_LOGIN_ATTEMPTS recorded?

From: <deebeeay_at_gmail.com>
Date: Wed, 17 Oct 2007 04:05:19 -0700
Message-ID: <1192619119.576784.29040@q5g2000prf.googlegroups.com>

On 16 Oct, 21:39, Steve Howard <stevedhow..._at_gmail.com> wrote:
> On Oct 16, 11:04 am, "deebe..._at_gmail.com" <deebe..._at_gmail.com> wrote:
>
> > Hi,
>
> > Using 10gR2 - trying to find out where FAILED_LOGIN_ATTEMPTS are
> > recorded.
> > FAILED_LOGIN_ATTEMPTS is currently set to 10 as per the Default
> > profile.
>
> > There is no auditing in place but failed logins for users must be
> > recorded somewhere (ie internal table) for the profile to work.
>
> > Cheers
> > D
>
> Hi,
>
> LCOUNT in user$ holds this information.
>
> HTH,
>
> Steve

Thanks alot Steve!

USER$ was exactly what I was looking for.

Cheers
D Received on Wed Oct 17 2007 - 06:05:19 CDT