Re: Who has just touched a row ?

You can use a trigger to insert a row in another table which is used just to track activity. This can be a "log" of activity against the table. You can carry a transaction date and time, user, function and see the result of the insert, update, or delete. It can be handy on an ongoing basis. Of course, you want to be sure to keep the "log" table from comsuming too much space. We have a handful of tables we track that way and have a periodic job that deletes rows oled than a specific interval (e.g. a month, three months, etc.). It can be very handy in pinpointing who did what, when. Good luck Con Woodall Colorado State University Veterinary Teaching Hospital cwoodall@vth.colostate.edu 970-491-1244 On Fri, 12 Mar 1999, Chuck Renaud wrote: > > Add a column "username" to the table and a trigger on update that SET > > username=USER to that row (I never used triggers and I'm not shure about > > if this it's possible But that's the idea). Hope this helps. > > I don't believe you can do this with IDS. You could update a row in > another table, but I don't think we allow updating the same row that > set off a trigger. Not that I wouldn't like to see that ability... >