How to assign a user the privilege to execute all stored procedures only?

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Ram Ram Ten Centuries Points: 1079 More actions · Answer 1

USE [DBName]

GO

SELECT 'GRANT ALL ON ['+Name+'] TO [User]' -- Change UserName here

FROM SysObjects

WHERE XType = 'P'

get the o/p query and run in QA.

Ram

Chaohua Wang-372299 SSC Veteran Points: 209 More actions · Answer 2

Is there any stored procedure we can use for this purpose?