On Wed, 7 Mar 2012 12:32:47 +0200, Nols Smit <[email protected]> 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>
