Subject RE: [firebird-support] Securities
Author Mark Rotteveel
On Wed, 7 Mar 2012 12:32:47 +0200, Nols Smit <nols@...>
>>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>