Confusion between Login and User in SQL Server
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:
Category: Security and encryption
Procedure with Execute as login?
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 …
