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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 sql 2005 users vs logins

Author  Topic 

BitShift
Yak Posting Veteran

98 Posts

Posted - 2007-02-08 : 17:16:30
What is the relationship between the users in a database and the logins on the server.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-02-08 : 17:21:12
Logins exist in the master database. Users exist in the user databases. Each user is mapped to a login. A login can be a Windows account or a SQL account.

Tara Kizer
Go to Top of Page
   

- Advertisement -