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

Grant all the stored procedures to a User

June 27, 2012

To Grant the permission for all the stored procedures to a User we can use the following command:

USE <DatabaseName>
GO
GRANT EXECUTE to <User>;
GO

 


%d bloggers like this: