Re: trigger to unsuccessfull login

Jonathan Lewis wrote:

> It's a long time since I last checked, but doesn't
> the audit_trail=db include an option to audit
> connect on failure ? Would that be sufficient
> for the original poster ?
>
> --
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Coming soon one-day tutorials:
> Cost Based Optimisation
> Trouble-shooting and Tuning
> Indexing Strategies
> (see http://www.jlcomp.demon.co.uk/tutorial.html )
>
> ____UK_______March 19th
> ____USA_(FL)_May 2nd
>
> Next Seminar dates:
> (see http://www.jlcomp.demon.co.uk/seminar.html )
>
> ____USA_(CA, TX)_August
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> DA Morgan wrote in message <3E4D1DF9.B8F5DDF2_at_exesolutions.com>...
> >Tanel Poder wrote:
> >
> >> Hello!
> >>
> >> You could write your own password verify function for Oracle and
> set it to
> >> all (any) users with PASSWORD_VERIFY_FUNCTION profile option. You
> could keep
> >> a log in some table - using autonomous transactions.
> >>
> >> I haven't tried it, but it should work if there's no specific
> restrictions
> >> during logon.
> >>
> >> Tanel.
> >>
> >> "DA Morgan" <damorgan_at_exesolutions.com> wrote in message
> >> news:3E4CB6D4.D01A1E83_at_exesolutions.com...
> >> > Andris Jancevskis wrote:
> >> >
> >> > > Hi!
> >> > >
> >> > > How can I check usuccessfull login attempt?
> >> > > I can check time when user lon in with database triger, but it
> is
> >> > > _after_ event. Should I modify trigger SYS_LOGON ?
> >> > >

Just checked and you are correct.

Daniel Morgan Received on Fri Feb 14 2003 - 15:29:03 CST