Bogdan Ene-Iordache wrote:
> 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 ...
Mmh, you know, that VB-procedures are not supported in the kernel
and that you have do do everything outside the kernel and in EVERY
application for your own?
> Isn't it something similar (monitor, audit, trace ecc)
> already done by
> the sapdb server (with the right parameters on) ?
Such kind of monitoring/auditing is not done in the kernel.
> Or maybe isn't it possible to use triggers and/or stored procedures ?
It is possible to use triggers (let's say, a trigger is a special form
of dbprocedure). If you use a trigger you can be sure that in every
case your insert/update/delete, the trigger is specified for, will be
called internally by the kernel. In case of dbprocedures it is your
job to assure that every application will do it in every case (hard
job
in case of SQL-statements changing/inserting/deleting several rows).
==> triggers are a good idea and as far as I remember one member
of this list did it before, but I don't remember his name.
Can he tell us something about his experiences?
Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
