SQL Query or Best way to find who all have access to run xp_cmdshell

  • Only sysadmins should have authority to use xp_cmdshell once it is enabled on the server. Whats the best way to find who all have access to xp_cmdshell?

  • Got my answer:

    Master Database

    Expand Programability --> Extended Stored Procedures --> System Extended Stored Procedures

    Right click sys.xp_cmdshell from the list

    Properties and Permission

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply