How to grant execute permissions to xp_cmdshell without sysadmin privileges?
Error: The EXECUTE permission was denied on the object ‘xp_cmdshell’, database ‘mssqlsystemresource’, schema ‘sys’.
The account needs public access to master and ‘execute’ permission on ‘xp cmdshell’.
GRANT EXECUTE ON xp_cmdshell TO [user]
475 Responses