how to grant select privilege on trigger to others
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.
Re: how to grant select privilege on trigger to others
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.
Originally posted by newbieonthebloc
Do miss something or what?
GRANT FIRE ON your_trigger TO myuser
You grant only CREATE, DROP, ALTER privs on Triggers !!
Last edited by patnams; 07-28-2004 at 02:01 AM.
Sridhar R Patnam
Click Here to Expand Forum to Full Width