More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
What's the difference between a server login and a database user?
Answer
A server login connects an account to the server. A database user the link from the server login to a defined database .
Explanation
You need to create a server login using CREATE LOGIN before you can then link it to a database using a database user with CREATE USER. The server login logs into the server and grants access to any server wide permissions. The server login is then mapped to a database user for access to database objects.
(Continued on next question...)
