Posts

Showing posts from June 7, 2012

Microsoft SQL Server 2005 :Grant Execute Stored Procedure to USER

/* Create a new role for executing stored    procedures */ CREATE ROLE db_executor /* Grant stored procedure execute rights    to the role */ GRANT EXECUTE TO db_executor /* Add a user to the db_executor role */ EXEC sp_addrolemember 'db_executor', ' Username '