Subject | Recording Update statements and User that executed |
---|---|
Author | Marius Labuschagne |
Post date | 2013-02-26T20:28:07Z |
Hi,
Is it possible to record any UPDATE statement that is executed against a
database, from the database level?
Something very strange happened to one of my Clients databases, where one
field in a table was set to another field in the same table (both double
precision fields). I suspect that this was executed by an end user using
one of the database tools like IBExpert or Database Workbench, but there is
no way that I can prove it.
After analysis of the data and my application, I found that the particular
UPDATE that was executed is not present at all anywhere in the source code
of the application.
Regards
Marius J. Labuschagne
Is it possible to record any UPDATE statement that is executed against a
database, from the database level?
Something very strange happened to one of my Clients databases, where one
field in a table was set to another field in the same table (both double
precision fields). I suspect that this was executed by an end user using
one of the database tools like IBExpert or Database Workbench, but there is
no way that I can prove it.
After analysis of the data and my application, I found that the particular
UPDATE that was executed is not present at all anywhere in the source code
of the application.
Regards
Marius J. Labuschagne