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 |
|
RoyalSher
Yak Posting Veteran
95 Posts |
 Posted - 2004-01-07 : 07:34:27
|
| Hi, I am bit perplexed in a situation. Can anybody tell me a way to grant permissions to alter stored procedures by a developer in development env. without giving role of db_ddladmin.?Thanks in advance.RoyalSher.*********The world is the great gymnasium where we come to make ourselves strong. |
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2004-01-07 : 10:45:36
|
grant db_owner |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-07 : 12:28:14
|
| If the objects are owned by dbo, then the user needs db_owner to alter them as well as to create them.Tara |
|
|
|
|
|
|
Roles