Record changes in tables

[jochenspeer]

Hi,
how can I track changes to the contents of a table in a certain time frame, which records have been added-deleted-modified?

Thanks

Jochen

 

[vpshriyan]

Hi,

Secure auditing features can be used to trace the successful or unsuccessful user activities in a database.

Get the full help:
onaudit

Current status:
onaudit -c

You can turn on auditing in one of the following:
1) onaudit -l 1
2) ADTMODE 1 #Auditing mode (configuration para)

Specify the directory for audit dump files:
1) onaudit -p /usr1/dbaudit
2) ADTPATH /usr1/dbaudit (configuration para)

Trace the manipulations (INSERT,UPDATE,DELETE) of the user jonathan.

onaudit -a -u jonathan -e +INRW,UPRW,DLRW

TIP: If the user list is huge, produce the input instructions in a form of a file. Each line of the instruction file should be in the form:
targetmask templatemask events

For example:
jonathan - +INRW,UPRW,DLRW
hari _sec2 +ALTB,DLRW -CRTR

To analyze the Audit File:
onshowaudit -u jonathan

Following is the link to informix Trusted Facility Manual here in you will find more about onaudit facility:

http://elib.cs.berkeley.edu/admin/informix/doc/answers/pubs/pdf/4808.pdf

Regards,
Shriyan