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 |
|
brandonl
Yak Posting Veteran
58 Posts |
 Posted - 2004-12-03 : 13:24:08
|
| Is there a quick way (via QA) to assign a database role (called WebSiteRole) to execute permissions on all user stored procedures in a database? I'm drawing a blank.~BrandonL |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-12-03 : 13:58:19
|
| copy the results of this and execute it:SELECT 'GRANT EXECUTE ON ' + name + ' TO WebSiteRoleFROM sysobjects WHERE type = 'p'rockmoose |
 |
|
|
brandonl
Yak Posting Veteran
58 Posts |
Posted - 2004-12-03 : 14:27:47
|
| Hmmm...I took the query and it gives an error. Missing a quotation mark. Attempting to fiddle around with where to place one :)~BrandonL |
|
|
|
brandonl
Yak Posting Veteran
58 Posts |
Posted - 2004-12-03 : 14:29:41
|
| Got it! Thanks rockmoose!~BrandonL |
|
|
|
|
|
|
Stored Procedure Permission Question