Re: Trigger Question

<amerar_at_iwc.net> a écrit dans le message de news: 1135187144.223361.107310_at_f14g2000cwb.googlegroups.com...
| 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
|

Trigger is executed in the session that executes the statement that fired it with the privileges of the owner of the trigger.

Regards
Michel Cadot Received on Wed Dec 21 2005 - 12:58:04 CST