We're now using database auditing in a deliberate way now, changing the
Audit_Trail to XML,Extended. The V$XML_Audit_Trail view gives us the the main
thing we want - the SQL and Binds. One puzzle is the Action column. We think it
points to the Audit_Actions DD view, but are confused by the Action value we
get in our DML Audit records. It's always 103, which is SESSION REC, not 2, 6,
or 7, which correspond to Insert, Update, and Delete.
Is this expected? When would Action be 2, 6, or 7 for DML transactions?
Thanks.
--
Jack C. Applewhite - Database Administrator
Austin I.S.D. - MIS Department
512.414.9250 (wk)
Confidentiality Notice: This email message, including all attachments, is for
the sole use of the intended recipient(s) and may contain confidential student
and/or employee information. Unauthorized use of disclosure is prohibited under
the federal Family Educational Rights & Privacy Act (20 U.S.C. §1232g, 34 CFR
Part 99, 19 TAC 247.2, Gov't Code 552.023, Educ. Code 21.355, 29 CFR
1630.14(b)(c)). If you are not the intended recipient, you may not use,
disclose, copy or disseminate this information. Please call the sender
immediately or reply by email and destroy all copies of the original message,
including attachments.