Subject Logging SQL statements on database.
Author michaeleubanks2000
I am using Firebird 2.1.1 and I would like to use some type of trigger
to log SQL statements that where executed on the database. I would also
like the trigger to log the IP Address, DateTime, and database user in
a table that looks somthing like this:

SQL IP ExecuteDateTime User
Select * from Customer 192.168.1.32 7/29/2008 3:21:00 JDOE


I have some experience writing stored procedures but I am not sure
where to start or even if it can be done.

Thanks,

Michael