Tag: connection

• Changing the Security Context with EXECUTE AS and REVERT

  

  2014-01-09 - Fundamentals, General, Security

  Constantly logging out and back in to test security settings and permissions can be cumbersome. Learn how EXECUTE AS can ease your life.

  [more…]

• The Secret of the Security Token – How SQL Server Determines Active Permissions

  

  2014-01-08 - Fundamentals, General, Security

  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.

  [more…]

• SQL Server Logins and the sys.server_principals catalog view

  

  2014-01-02 - DMVs & CVs, Fundamentals, General, Security, Security

  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.

  [more…]