Quote:
Originally posted by lacey
yes that is true however you can not grant object level privileges with triggers or procedures....the only options you have is to grant a user "execute any procedure" or "execute any trigger" or actually have the user own the procedure or the trigger.....I know this sucks...I have had a similar problem in the past...and unless this has changed you either have to have the user own the object or grant execute any.......
1. There is no such privilege as "GRANT EXECUTE ANY TRIGGER". Triggers are executed automatically, you can't (directly) control for which user they will be executed and for which won't.