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

Thread: priveledges

  1. #1
    Join Date
    Mar 2001
    Posts
    82

    Angry

    Assuming the dba wants to give a user the priveledge
    to execute only 4 procedures (PROC_1,PROC_2, PROC_3, PROC_4)
    How would you grant priveledge to a user

    NOTE: I do not want to grant the user
    EXECUTE ANY PROCEDURE priveledge.

    NOTE: I did not find this in any docs.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    1. logon to the owner's schema
    2. GRANT EXECUTE ON PROC_1 TO username
    3. GRANT EXECUTE ON PROC_2 TO username
    4. GRANT EXECUTE ON PROC_3 TO username
    5. GRANT EXECUTE ON PROC_4 TO username
    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
    Mar 2001
    Posts
    82
    thanks

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