Use of Triggers for auditing changes

Author: asktom.oracle.com | Published: 21st Sep 2007 | Visited: 155 times | Add Comment
Filed in: Oracle FAQ

We are developing an OLTP system on the J2EE framework. System expected to be up for at least 17 hours.The DB is ORACLE ver 10.2.0.2.0.There is a functionality(technical) expected to audit 'certain' transactional data. We intend to use ORACLE DB ...

Read Article

Sponsored Links

• Programatically Creating MSMQ Triggers An article on creating MSMQ triggers manually at runtime and firing it to take a custom ac ...

• SQL ASSERTIONS vs triggers, materialized views with constraints, etc I attended a Hotsos session by Toon Koppelaars yesterday morning on Semantic Query Optimization. Among other interesting topics, Toon lamented the lack of any DBMS implementing SQL "assertions". By which he meant a database-enforced constraint tha ...

• Business Rules - Triggers, Foreign Keys or Stored Procedures Hi Tom, I would like to ask for your advice on the most effective way, with respect to performance and management of code, to enforce the following example business constraint relating to relationships involving sub-types. Consider the follow ...

• CLR Triggers for SQL Server 2005 In this article Soyuj describes different type of triggers, more specially CLR triggers, and their uses. It covers examples for creating T-SQL as well as CLR Trigg ...

• A Guided Tour of WPF ? Part 4 (Data templates and triggers) A guided tour of the Windows Presentation Foundation, one feature at a t ...

• Implementing Triggers in 4D The targeted audience of the article are the novice 4D developers and aims at explaining the usage of Triggers in 4D databa ...

• Auditing Users Accessing Confidential Data <code>Hi My client had a requirement to log users accessing certain fields in a table. I found DBMS_FGA to fulfill this requirement. Its logging the query used to access the data by the user. But now the client says, he wants to log the Key va ...

• SharePoint Server 2007 Code Sample: Item-Level Auditing This code sample shows you how to create an item-level auditing view programmatically in three different ways: using a custom SharePoint list, through the Excel client, and by manipulating the open XML file format to display auditing hist ...

• Auditing Users Accessing Confidential Data Hi My client had a requirement to log users accessing certain fields in a table. I found DBMS_FGA to fulfill this requirement. Its logging the query used to access the data by the user. But now the client says, he wants to log the Key value of ...

Next: distributed query and undo/redo