Posted by Erland Sommarskog on 07/14/05 11:46

New MSSQL DBA (boscong88@gmail.com) writes:
> How can uid of users in all the databases be the same??
>
> Say I've got 5 logins, all of them have access to system database and
> only 1 of them has access to DB_A and another 1 has access to DB_B,
> then how is it possible that the users for these logins in different
> database be of the same uid?

Not really sure what you mean, but uid is a database-specific id, so id
17 in db_A can be user Ture and in db_B it's user Ingvar. Which may or
may not map to the same login.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]