Question
Server logins versus database users: how do their security scopes differ?
Answer
Logins authenticate at the instance; users authorize access within a database. Create a login for instance authentication, then map it to database users only where access is required.