Constantly logging out and back in to test security settings and permissions can be cumbersome. Learn how EXECUTE AS can ease your life.
To determine the active permissions for a connection, SQL Server uses a list of security tokens. Read on to find out what these mysterious tokens are and how to see the list of active ones.
SQL Server knows two types of security principals: The login or server principal and the database user or database principal. Read on to learn more about the server principal.