Hello Michael,

> 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?

Yes, by querying the MON$ tables joining with some DB trigger context
information (CURRENT_CONNECTION, CURRENT_TRANSACTION ...), although I'm
not sure about the performance penalty.



--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/

Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/