Auditing the Data

You may want to track the following while using a business application:

• Insertion of new data
• Deletion of existing data
• Modification of existing data

Application auditing is used if the changes to the table columns need to be tracked and column values need to be stored for each change. The Oracle Database allows application auditing by using either stored procedures or database triggers.

To create an audit system, you need to create an audit table.This table is used to keep track of the changes to the data. When the database trigger fires, records are inserted into the audit table.