audit all DML of all users
840275Sep 22 2011 — edited Sep 22 2011Hi,
since the archivelog grows too much i would like to audit the database activity.
The following sql doesn't audit all users, and i would like to know why.
There are several schemas in the bd and the DBA_AUDIT_TRAIL completely lack of any DML of one schema (there is activity on this schema so DBA_AUDIT_TRAIL should contain information about it)
AUDIT UPDATE TABLE ,insert TABLE, delete TABLE
by access ;
Do someone has any idea why?
(the oracle version is 10.2g)
Thank you in advance:
Bianca