|Subject||Re: [ib-support] Connect to DB from Procedure ??|
> I need the logging to be independent of the program, to log all reads,- if you need to log reads, you have to use stored procedures, because there are no select-triggers
> 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.
- you need to use transaction independent method (such as UDF, or better yet external files);
otherwise user can read whole database and then just finish with Rollback,
and your log will remain empty!