SQL Server DBA

Security, authentication, authorization, and auditing

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.

This is 13 of 25 free samples for SQL Server DBA.

More SQL Server DBA topic samples