There is often confusion between Login and User in SQL Server. What is the difference and what is the link? I hope to clear that out in this short video:

Sometimes we need a low-privileged user to do a specific administration task or task that require some server-level permissions (such as VIEW SERVER STATE, ALTER TRACE etc). Of course, we do not want to give that account server-level privilege, because…