Subject | Logging SQL statements on database. |
---|---|
Author | michaeleubanks2000 |
Post date | 2008-07-29T20:24:25Z |
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
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