Currently i have enabled auditing for a particular user in db(9i rel2).
i want audit enabled for the following events (all ddl, dml,dcl) as well as logon).
i can see the audited log on event in the data dictionary audit views (nameley sys.aud$, dba_audit_object, dba_audit_session, dba_audit_trail) . but in all of these views the action_name column
only shows an entry named session_rec and does not specify create, select , alter , delete , grant etc (all which i want to be audited)
AUDIT does not audit DML, RTFM
Click Here to Expand Forum to Full Width