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.
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