amerar_at_iwc.net wrote:
> Hey All,
>
> Quick question here:
>
> Say I have Schema S1, with Table T1. I have a public synonym on T1, as
> well as a trigger on T1.
>
> I log in as user #2 in Schema T2 and insert a value into table T1.
>
> When the trigger fires, does that create a new session? Or, is the
> session owned by user #2?
>
> Thanks
The session is the session. The behaviour would only change if the
trigger were created with PRAGMA AUTONOMOUS_TRANSACTION.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Dec 21 2005 - 12:53:07 CST
