Re: trigger to unsuccessfull login

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Fri, 14 Feb 2003 01:28:52 -0800
Message-ID: <3E4CB6D4.D01A1E83@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 ?
>
> I don't like to do this.
>
> cheers,
> Andris

AFAIK unsuccessful attempts can not be trapped inside the database unless the SYSTEM trigger AFTER SERVERERROR or something like it catches them. I haven't really checked.

I will be very interested in responses that may indicate a means of doing so other than in the operating system.

But the reason I have never cared much is that I always alter the default profile to lock any account after three attempts at the password. It really makes cracking painfully hard to do and impossible for a program that tries different combinations. It only gets to try 3 every three days.

Daniel Morgan Received on Fri Feb 14 2003 - 03:28:52 CST