--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...>
wrote:
Hi Adam,

what I am looking for is to track what changes are being made by
every transaction..say I have field "name" which has
value "adam"..someone changes it to "adams2"..i want to be able to
track in such a way that old as well as new value are stored in an
audit table..
What do you mean by data abstraction layer? what 3rd party tools you
r talking about?
thks

> Hello Vishy,
>
> That is an unusual question. What information are you after? I am

now

> guessing at what you are after, so be more specific in your

question if

> this is not it.
>
> Is there a way to track which user ran which queries / SP's etc

and

> when?
>
> No built in way, however there are third party products that do

allow

> you to log different things.
>
> If your application has any sort of data abstraction layer, then
> logging becomes quite a trivial (but time consuming) task.