Triggers
From: The Magnet <art_at_unsu.com>
Date: Tue, 8 Sep 2009 09:05:10 -0700 (PDT)
Message-ID: <a5596bf1-1193-422d-a78e-e28964da8291_at_y36g2000yqh.googlegroups.com>
Date: Tue, 8 Sep 2009 09:05:10 -0700 (PDT)
Message-ID: <a5596bf1-1193-422d-a78e-e28964da8291_at_y36g2000yqh.googlegroups.com>
Hi,
Probably a nutty question, but, is it possible to find out what program contained the DML which fired the trigger?
We have a particular situation, and next to mining the logs, we're not sure how to find who or what is updating a certain row. So, we should a trigger on the table testing for this particular user ID and capturing information is the best way to go.
If there are others, I'm all ears. Received on Tue Sep 08 2009 - 11:05:10 CDT