how to grant select privilege on trigger to others
Hi,
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.
James.
Re: how to grant select privilege on trigger to others
Quote:
Originally posted by newbieonthebloc
Do miss something or what?
You have missed the concept of what a trigger is. Read the concepts guide at http://tahiti.oracle.com twice and ask your question again if you need to.