Discussion in 'General DBA Questions' started by tsusanto, Mar 9, 2004.
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.
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
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.
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Separate names with a comma.