Re: Forms: reusable pre-insert trigger

This is a good idea too.
We once had a special user called 'data_loader' which when used, didn't fire any audit triggers.

M

rtproffitt_at_my-deja.com wrote in message <7l86c9$kl5$1_at_nnrp1.deja.com>...
>Another alternative would be to alter the table design,
>and put triggers on the tables to update with USER and SYSDATE.
>Then the application does not have to take the responsibility
>for guaranteeing the audit trail.
>
>(If you did so, you would have to find a way perhaps to disable
>the trigger on bulk updates...We used a special username for
>all Load processes and triggers contained an IF statement.
>We felt this was better than Disabling and Enabling triggers
>all the time).
>
>Robert Proffitt
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Tue Jun 29 1999 - 10:01:51 CEST