SQL Server Performance Forum – Threads Archive

xp_cmdshell permissions

How do I see who has permission to execute xp_cmdshell?
btw..this forum can be very addictive…

Open Master database, extended stored procedures and right click on properties for xp_cmdshell.

Hi, Go to Enterprise Manager>Databases>master db.>Extended Stored Procedures.
Right click on xp_cmdshell sp.> All Tasks>Manage Permissions or you can use this query from QA:
select u.name from syspermissions p,sysusers u
where p.id =(object_id(‘xp_cmdshell’))
and u.uid = p.grantee Alex

By default, only members of the sysadmin fixed server role can execute this extended stored procedure. You may, however, grant other users permission to execute this stored procedure. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>