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 |
|
dsvick
Starting Member
6 Posts |
 Posted - 2011-05-31 : 13:14:51
|
| I've got a question that I've looked online for an answer to and can't seem to find.We have a new developer and I need to give them access to the dev and live servers. I've created the login but wanted to know if there was an easier way to give them access to the several dozen existing databases other than assigning them as a user in each and giving them the appropriate roles. Essentially I want them to have reader, writer, ddl, and owner roles for all existing and future user defined databases.Needless to say, I don't want to give them sysadmin either. Any help or a nudge in the right direction would be appreciated.thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dsvick
Starting Member
6 Posts |
Posted - 2011-05-31 : 14:21:57
|
| Awesome, thanks Tara, I should have thought of model myself, but it was manually updating the existing that had my attention :) |
 |
|
|
|
|
|
Permissions for new developer