Read only access to stored procedure contents

user_64279 0
Viewed 79668

Is it possible to set up SQL Server to give developers read-only access to the contents of stored procedures on our production database?

sql-server-2005 sql-server-2008 sql-server
6 Answers

DB Name --> Security --> Users --> Right Click User name --> Properties --> select Securables --> Click Search --> select All Objects of type --> Check Stored Procedures --> Check View Definition --> OK.

enter image description here

enter image description here

enter image description here

enter image description here

enter image description here

user_46813410

While i know this is late in response to the question, but for those people that have come here looking for an answer (just as I did a few minutes ago) in at least SQL management studio 2014 you can edit the user account and edit the permissions in the SECURABLES area and tick all the boxes in VIEW that you want them to have access to.

This does the above without having to run scripts.

user_50610030
Related