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 |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2005-06-06 : 09:33:18
|
| Does anyone have a script that enables me to loop through all the stored procedures with a given prefix (eg just ones starting "mp_") and then grant execute permission to each one for a given role?I dont want to build a string up that I then run as a statement. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-06 : 16:21:05
|
| Yes I do. Search the forums for isp_Grant_Permissions. I've posted it a few times and it does exactly what you're asking.Not sure why you don't want to build up a string as that's what you have to do for this.Tara |
 |
|
|
|
|
|
loop and grant