On Wed, 7 Mar 2012 12:32:47 +0200, Nols Smit <nols@...>
wrote:

>>Did you grant the necessary rights to the trigger itself? I might be
>>wrong, but if no rights are granted to the trigger, then the caller
>>permission is used.
>
> I can't figure out how to associate a role to a trigger.
>
> I gave all privileges to the trigger on its table but that did not help.
>
> (I'm using IBExpert to control the securities)

I am not sure if you can assign a role to a trigger (you might want to
consult the IB 6 manual on that), but you can do
GRANT <privileges> ON <object> TO TRIGGER <name of trigger>