Re: Database Triggers

Posted in 1998

John Smith — Wed, 1 Apr 1998 20:54:29 -0600 — source: Informix-list mailing list archive (1991-1998)

Triggers are useful for all kinds of things. I use them to set audit trails on users that are modifying critical data. Whenever a user updates or inserts a record, I have the trigger capture userid, a before/after image of record and timestamp. User never knows it, and we have fired several employes for misusing company data this way. James John Bedford wrote in message <35227240.C65301BD@dmu.ac.uk>... >Hi, > >I'm currently doing a project on Active Database Systems and I am >interested to know if anyone >actually implements triggers within their database systems and what >they find them most useful for?. I'm also interested to know of any >problems encountered with using triggers. > >Any feedback would be very grateful, > >Thanks, > >- john