Thursday, 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'

No comments:

Post a Comment

Dear User,

Thank you very much for your kind response