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 |
|
doran_doran
Posting Yak Master
179 Posts |
 Posted - 2009-12-23 : 13:11:11
|
| I did following per this article http://www.sqldbatips.com/showarticle.asp?ID=8/* CREATE A NEW ROLE */CREATE ROLE db_executor/* GRANT EXECUTE TO THE ROLE */GRANT EXECUTE TO db_executorHow do SSMS knows to create this role to execute all the stored procs? |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-12-23 : 14:32:52
|
| i believe that is the default behaviour for EXECUTE<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
|
|
|
Granting Execute Permission