Hi, I need to to develop an application which keeps audit trails about all the changes performed by all the users of the system. I mean, I should save a record about WHO, WHAT, and WHEN the changes were made. For example, a table should contain at least columns like: ID_USER (who made the change: add, delete, update) COL_DESCRIPTION (like TABLE.COLUMN) COL_VALUE (like TABLE.COLUMN.OLD_VALUE) TIME_CHANGE (TIMESTAMP value) ID_EVENT (like ADD, UPDATE, DELETE)
I use VB 6.0 + ADO on Win NT. I am thinking to write a procedure in VB to generate everything when the events are performed, but before doing something, I am wondering if there is not a simpler way ... Isn't it something similar (monitor, audit, trace ecc) already done by the sapdb server (with the right parameters on) ? Or maybe isn't it possible to use triggers and/or stored procedures ? Thanks to all that will give any idea. Bogdan Ene Mario Negri Institute _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
