-
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
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.
Jeff Hunter
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|