Re: Data auditing: triggers vs application code

On 9/21/05, Sandeep Dubey <dubey.sandeep_at_gmail.com> wrote:
> 1. Create triggers on the live table. For each insert/update/delete insert a
> row in the audit table.

Strange and unexpected things can happen with audit triggers. They can fire 2+ times for the same row in the right circumstances.

See:

http://tkyte.blogspot.com/2005/08/something-different-part-i-of-iii.html
http://tkyte.blogspot.com/2005/08/part-ii-seeing-restart.html
http://tkyte.blogspot.com/2005/09/part-iii-why-is-restart-important-to.html

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l