wildthing68
IS-IT--Management
I want to create an audit trail system in my db but only on certain tables and columns. I know I can do:
IF UPDATE(col1)
.
.
IF UPDATE(col2)
.
etc, etc
what I whant to do is pull in the list of updated columns from the triggering command so I can use a table to control the auditted columns.
Does anyone know where this information is held?
Cheers
ps 11.9.2 on Linux
IF UPDATE(col1)
.
.
IF UPDATE(col2)
.
etc, etc
what I whant to do is pull in the list of updated columns from the triggering command so I can use a table to control the auditted columns.
Does anyone know where this information is held?
Cheers
ps 11.9.2 on Linux