Re: Who locked these ROWS ??
From: Jonathan Wayne Ingram <jwingram_at_whale.st.usm.edu>
Date: 1995/10/12
Message-ID: <45j7kg$ibn_at_thorn.cc.usm.edu>#1/1
Date: 1995/10/12
Message-ID: <45j7kg$ibn_at_thorn.cc.usm.edu>#1/1
Jagannath Poosarla (poosarla_at_aadt.com) wrote:
: Is it possible to find out in a trigger which OS user has locked the row for which the
: insert/update/delete trigger was fired.
Of course. The person who performed the insert fired the trigger.
Ergo, that person locked the rows. Select user from dual;
Jonathan Received on Thu Oct 12 1995 - 00:00:00 CET