how to grant select privilege on trigger to others
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how to grant select privilege on trigger to others

  1. #1
    Join Date
    Jul 2004
    Posts
    2

    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.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175
    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
  •  



Click Here to Expand Forum to Full Width