Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2006
    Posts
    31

    Unanswered: Access to Extended Stored Procedures

    Hi,

    How can I remove access to extended (xp_) stored procedures?
    Is there any revoke on <stored_procedure_name> ... command? How can I generate a script of all users who have execute privileges for these procedures? Also, is there any way of restricting (instead of removing) access to those procedures?

    Any help will be greatly appreciated!!!
    Thanks,
    Alla

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Code:
    revoke execute on xp_fixeddrives from public

  3. #3
    Join Date
    Nov 2006
    Posts
    31
    Thanks! Also, how can I review which stored procedures public has execute privileges for?

    Thanks in advance!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •