How to trace activity on the database??

[aljubicic]

Is there a way of tracing activity on an informix database running on a linux system. So it tracks all INSERTS, DELETES and UPDATES from user activity.

 

[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

Regards,
Shriyan