Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: monitor failed login attempts

Re: monitor failed login attempts

From: StefanKapitza <skapitza_at_volcanomail.com>
Date: 25 Oct 2005 02:39:54 -0700
Message-ID: <1130233194.071876.218750@z14g2000cwz.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US