Subject Re: [firebird-support] Database triggers
Author Aage Johansen
Alexandre Benson Smith wrote:
> Aage Johansen wrote:
>> Is it possible to use the CONNECT event of the database triggers to
>> catch failed attempts to log in to a database?
>> ...
>
> Never tried that.. but I don't think so.
>
> Anyway you are asking for information that is not available to firebird
> (the user that is logged at the PC)
>
> From the release notes:
> ...
> As you can see the first step is a connection to the database, if you
> provide a bad login, no connection would be established.
>
> HTH
>
> see you !
>

Thanks for the confirmation. I had read the ReleaseNotes, and I'm
not surprised.

Now, catching/logging those failed connection attempts could be a
security feature. Would it be a feature worth considering?
As for username (logged in at the PC) and other info: the client dll
might transfer it, and it could be saved in a monitoring table.

--
Aage J.