Auditing Oracle Data

Tuesday Mar 16th 2004 by Staff

Learn how to create an audit trail for application data on an Oracle database (Oracle 8 and up). It includes two scripts that can be used to quickly get started.


Auditing data of business applications is a common requirement. In this article, I'll demonstrate one way to audit Oracle data that is both simple and flexible. The code is written in Oracle PL/SQL and can be applied to any modern Oracle database. The process demonstrated can be duplicated on many other databases by using their default programming language.

Auditing Options
There are several different ways to audit database activity. In Oracle, you may audit things such as database connections, user logins, and so on, storing the results in a data dictionary table.

The article continues at

Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved