Audit DML changes

[Ramg]

I am trying to set up auditing using Audit_trail to audit all DML activities of a particular schema(out of many schemas in the same DB/9.2.0.7/AIX).

The following statement only creates entry in sys.Aud$ if I use schema to connect and run DML. If I use DBA id or SYS id to run DML on this schema, it is not capturing the changes.


AUDIT INSERT TABLE, UPDATE TABLE, DELETE TABLE by MARS(schema name) by access;


Any one having any idea, how to make sure it captured all DML activities on the schema by all users including DBAs mainly.

(I want to try triggers as last option).

Thanks in advance for your input.

[Ramg]

Common Friends! If dbasupport.com forum not helps, no one can help...

someone jump in before I become mad by RTFM(not finding any valuable info so far in reading/searching including metalink).

[tamilselvan]

AUDIT INSERT TABLE, UPDATE TABLE, DELETE TABLE by MARS(schema name) by access;

The above statement enables auditing for the user MARS only.
It will not audit other user's DML statement.

Tamil