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 |
|
Carat
Yak Posting Veteran
92 Posts |
 Posted - 2009-09-24 : 10:32:21
|
| I need to give a developer the permission to create a procedure on every existing schema in the database.Do I have to specify 'grant alter on schema:: dbo to TestUser' for each existing schema? Or is there another way to do this in one single line?Thanks |
|
|
|
|
|
grant create procedure permission on all schemas