On Tue, 15 May 2012 07:02:01 -0000, "Michael Vilhelmsen"
<Michael.Vilhelmsen@...> wrote:

> Hi
>
> I have en external connection to one of our DBs.
> I suspect this connection to do some heavy DB querys.
>
> I have created an DB trigger to log connect, disconnect, start, commit

and

> rollback from this user (and 3 others as a reference).
>
> Is there anyway I can save the SQL the user is executing?
> I use Firebird 2.1 (WI-V6.3.4.18393 Firebird 2.1) running on Windows

2003.

With Firebird 2.5 you would be able to use the trace API to store the
executed SQL. Other than that, I believe FBScanner does what you want (it
will sit as a proxy between the user and the actual database).

Mark