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 |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2011-01-21 : 08:54:03
|
| Hi all,i have a small doubt please clarify me.is there only one user for a login is sql server2005 or else we can map two to three users to one single login.i got this doubt because i created a db and added a new user(ttt) and mapped it to one login TT which already has one user(TT).so, it says that TT login has already got one user so why it so...please let me know about this. |
|
|
namman
Constraint Violating Yak Guru
285 Posts |
Posted - 2011-01-21 : 22:15:09
|
| One login can map to many users in different DBs, but not in the same DB. Ex: login1 can map to user1 in db1 and user2 in db2. But login1 can NOT map to 2 different users in the same db. |
 |
|
|
|
|
|
User login