1) What is difference between login
and user?
SQL Login is for Authentication and SQL Server User is
for Authorization. Authentication can decide if we have permissions to
access the server or not and Authorization decides what are different
operations we can do in a database. Login are created at the SQL Server
instance level and User is created at SQL Server database level. We can
have multiple user from different database connected to a single login to a
server.
