Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
allan8964
Posting Yak Master
249 Posts |
 Posted - 2012-02-07 : 14:36:44
|
| hi there,What role should be given to allow accessing Stored Procedures in sql server 2008 R2? Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-07 : 15:13:04
|
| what do you mean by accesing sp? do you executing sp or just seeing sp definition?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
allan8964
Posting Yak Master
249 Posts |
Posted - 2012-02-07 : 17:14:35
|
| OK, I mean add some developers to a db to let them able to see and modify the stored procedures. I know if I give them dbowner they can do that but that's too high. Is there any siongle one or some combinations of roles to offer? Thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-07 : 20:33:57
|
| why not GRANT them access to specific procedures using GRANT command?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
what role should be added for accessing sp?