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 |
|
DBA007
Posting Yak Master
145 Posts |
 Posted - 2010-10-21 : 14:24:51
|
| can any one provide details on how to give permission for a login to create,alter,drop procedure with out db_owner,db_ddladmin |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2010-10-21 : 15:02:34
|
| because this is a production |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2010-10-22 : 10:05:11
|
| Just a guess: you want them to be able to modify Stored Procs but not Table structure? If so, what we did, and this is the only way I know of - give them Owner - then assign them to a role - then write a Database Trigger that prevents members of that role from any type of Table modification. |
|
|
|
|
|
|
permission