Subject Re: Connect to DB from Procedure ??
Author Alexander V.Nevsky
--- In ib-support@y..., Damian Dowling <it-manager@p...> wrote:
> I need the logging to be independent of the program, to log all
reads,
> updates, etc from all programs. One of the requirements is the
logging of
> what was read by a user even when they are using a 3rd party
reporting 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.