What is the reason behind having both login and a user ?

 Posted by Bharathi Cherukuri on 7/24/2012 | Category: Sql Server Interview questions | Views: 1397 | Points: 40

By using both login and user, the database server can do the authentication process.
The authorization process can be scoped to the database.
With this advantage, if your database server is moved to another server, then also you can remap the user-login relationship on the database server, but your database need not to be changed.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response