dcsimg
 

Capture an Oracle 10g audit trail in XML format

Thursday Jan 24th 2008 by DatabaseJournal.com Staff

The Oracle database has long had the ability to audit selected types of operations against the database, storing the audit trail in a system table. This table, SYS.AUD$, resides in the data dictionary. On some operating systems, you can also write audit records to the operating system's own event logging subsystem.

[From Builder AU]

The Oracle database has long had the ability to audit selected types of operations against the database, storing the audit trail in a system table. This table, SYS.AUD$, resides in the data dictionary. On some operating systems, you can also write audit records to the operating system's own event logging subsystem.

Oracle 10g added a third option: The ability to write to files in an operating system directory. These files can be written in XML.

The article continues at http://www.builderau.com.au/program/oracle/soa/Capture-an-Oracle-10g-audit-trail-in-XML-format/0,339028441,339285373,00.htm

Home
Mobile Site | Full Site