Answer:
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