Post reply

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

  • February 10, 2010 at 9:01 am

    #141274

    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?

  • February 10, 2010 at 9:25 am

    #1116941

    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 1 (of 1 total)

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