Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Where are FAILED_LOGIN_ATTEMPTS recorded?
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 Received on Tue Oct 16 2007 - 15:39:27 CDT