SQL Server Performance Forum – Threads Archive
xp_cmdshell permissionsHow 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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.