V$XML_Audit_Trail.Action
Date: Fri, 6 Oct 2017 17:39:31 +0000
Message-ID: <CY4PR02MB27920F9606233281FD3492EEE6710_at_CY4PR02MB2792.namprd02.prod.outlook.com>
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.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 06 2017 - 19:39:31 CEST