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 |
|
jhermiz
3564 Posts |
 Posted - 2004-11-22 : 11:32:36
|
| A developer here wants client and tools installed.I dont mind if he sees the other databases in EM but I dont want him pokering around with it. When I install client and tools will it ask for a login cause I dont remember seeing that last time?Correct me if I am wrong but are these the right steps so that this user doesnt access the other db's:1)in em I went to security logins2)right clicked and did an "add new"3)entered a name "test"4)selected sql server authentication and put in a password5)selected the default db as his own db.6)then i went to the database access tab and selected two of the databases he needs access to.7)when i selected that database it shows "Permit in database role"with public checked true. So I left that alone.Is that all I need to do ?Thanks,Jon |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-22 : 14:18:53
|
| The installation will not ask for a userid and password. But if you want him to use SQL authentication, then you set that up when you register the server in EM. As long as his userid does not have any access to the other databases, then he won't be able to see anything inside them. He'll be able to see the database name though.Tara |
 |
|
|
jhermiz
3564 Posts |
Posted - 2004-11-22 : 15:24:50
|
| thanks T!jon |
|
|
|
|
|
|
just to make sure...