Who has shot a trigger ?

We are running Online 7.23 on Solaris, and there are several clientes connecting to the server ... When someone touches a tuple, there is a trigger that makes a copy of the tuple in other table ... but we must know from that trigger or from a procedure wich client or better wich user has made the trigger to run ... any idea ? thanks. -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

cnovo@my-dejanews.com wrote: > > We are running Online 7.23 on Solaris, and there are several clientes > connecting to the server ... > > When someone touches a tuple, there is a trigger that makes a copy of > the tuple in other table ... but we must know from that trigger or from > a procedure wich client or better wich user has made the trigger to run ... > > any idea ? Just add a users column to the audit table and insert "USER" into that column in the ON EVERY ROW clause. Art S. Kagel