Auditing Oracle Data

Tuesday Mar 16th 2004 by DatabaseJournal.com Staff
Share:

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.

[From Developer.com]

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 http://www.developer.com/db/article.php/3326371

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