On Tue, 15 May 2012 07:02:01 -0000, "Michael Vilhelmsen" <[email protected]> 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
