DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Syntax for assigning privileges to roles

  1. #1
    Join Date
    Apr 2001
    Posts
    55

    Syntax for assigning privileges to roles

    Hi everyone....
    I seem to have a memory block today, seeing as its still very early on a monday morning.

    Can someone tell me the syntax to assign privileges to a certain oracle role.

    Thanks

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    The same way you assign them to users

    GRANT priv TO role;

    HTH
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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