I am trying to grant select privs on trigger to other users. but I was getting error synonyms were invalid. But I do see that the synonym for the trigger is valid. Do miss something or what?
I have successfully grant select on tables,views,types,function,procedures,packages to others. but not on triggers.
Thanks for help.