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 |
|
paulland
Starting Member
7 Posts |
 Posted - 2009-05-05 : 21:16:17
|
How can I set up security (using windows authentication) within a SQL server instance so that if there are two databases I can allow a user to access Management Studio but only have admin access to a particular DB?The user needs DBA rights on *one* database -- he's a developer and will write SPs, create tables, etc -- but I do *not* want to make him a sysadmin on the server. I've dug into the manuals and Googled my heart out but can't figure out how to set this up.Any suggestions? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-05-05 : 21:33:24
|
| Add his login to the db_owner role for just that database, and make sure he does not have access to the others. |
 |
|
|
|
|
|
Selective DB security within a server instance