How to Grant the Execute permission of xp_cmdshell to a user?

July 23, 2012

To Grant the Execute permission of xp_cmdshell to a user you have to execute the following command:

GRANT exec ON sys.xp_cmdshell TO [User]
GO

 

Advertisements

How to Enable xp_cmdshell in SQL Server 2005/2008?

July 10, 2012

The built-in extended stored procedure xp_cmdshell is very much needed for DBA and Developers. By using this extended stored procedure we have the ability to run the Command line utilities/process. We can use this extended stored procedure in Stored Procedures and Job Schedules.

How to enable xp_cmdshell?

sp_configure ‘xp_cmdshell’, ‘1’

 


%d bloggers like this: