Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: monitor failed login attempts
jeffchirco_at_gmail.com wrote:
> Is there a way to find out what OS user had a failed login attempt to
> Oracle because of wrong password? Or any way to tell somebody tried to
> login but was unsucessful?
> Thanks.
>
> Jeff
check the audit option ("audit session whenever not successful")
OsUser is stored in sys.aud$ (IIRC column spare1)
regards
stefan Kapitza Received on Tue Oct 25 2005 - 04:39:54 CDT
![]() |
![]() |