Subject | Re: Connect to DB from Procedure ?? |
---|---|
Author | Alexander V.Nevsky |
Post date | 2001-08-08T10:13:49Z |
--- In ib-support@y..., Damian Dowling <it-manager@p...> wrote:
Hi, Damian. External log interest me too. I have 2 questions:
1. How can you know about someone made a Select statement from 3rd
party tool?
2. What if data changing actions logged by your SP/UDF (I thought
about trigger/UDF) will be rolled back?
When I asked it some time ago in IBDI group I got recommendation to
use events for external logging, but it seems much overhead - I
could'nt find a way to force event carry information about what record
and columns was changed, only table and performed action.
Best regards.
> I need the logging to be independent of the program, to log allreads,
> updates, etc from all programs. One of the requirements is thelogging of
> what was read by a user even when they are using a 3rd partyreporting tool.
Hi, Damian. External log interest me too. I have 2 questions:
1. How can you know about someone made a Select statement from 3rd
party tool?
2. What if data changing actions logged by your SP/UDF (I thought
about trigger/UDF) will be rolled back?
When I asked it some time ago in IBDI group I got recommendation to
use events for external logging, but it seems much overhead - I
could'nt find a way to force event carry information about what record
and columns was changed, only table and performed action.
Best regards.