SQL Server Security: Users
As mentioned earlier, server access is provided by logins, but database access is provided by users. As users are database-specific, they are created in the user databases and stored in the sysusers table. When a user is created in a database, it must be mapped to a login to provide access. Typically, the user account and login would be the same, such as mapping the login “sales” to a user “sales”; however, they are separate objects, so this convention is not enforced. It should also be noted that the database “user” doesn't always represent a single person. As in the previous example, the user “sales” could be mapped to a Windows group login “sales,” which could represent many actual Windows accounts. This allows you ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
