>>i would like to ask someone experienced, how to realize this db
>>logging:
>>
>>I wrote an user db application with D2005, FireBird 1.5 and IBO,
>>where data-aware components are used only. Access to the server
>>is realized via one user account and app-based security.
>>
>>I would like to set up server-sided logging of user actions
>>on server (inserts, updates and deleting). Using stored procedures?
>>
>>I don't know how to pass user context variable to the server.
>>(when all users using one account only)
>>
>>So in short, can you help me, how to log user actions on db server,
>>please?
>
>
> Seriously, the fastest way for you to do this would be by using
> our product called "IB LogManager". Check it out at
> www.upscene.com
>
> It's a very low-priced product and will save you hours of testing
> and programming.

And this even applies to users of the IBO Global DML Caching mechanism.
More information on the DML Caching integrator facility in IB LogManager
is available here:
http://www.upscene.com/products/audit/iblm_ibo_dml_caching_main.htm


--
HTH,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2 (NEW!)
Upscene Productions
http://www.upscene.com