Tag: security

• How to identify the SQL Server Service Account in T-SQL

  

  2014-01-23 - General, Security

  In SP1 for SQL 2008R2 a new DMV was introduced: sys.dm_server_service. It provides information about SQL related services including the service account name. Read on to get all the details.

  [more…]

• ORIGINAL_LOGIN() – How to identify the Original Login Name

  

  2014-01-22 - General, Security

  ORIGINAL_LOGIN() is a SQL Server function that returns the original login name that was used to make the connection to the instance. Read on to get all the details.

  [more…]

• The Mystery of the SUSER_NAME() and SUSER_SNAME() functions

  

  2014-01-11 - Fundamentals, General, Security

  The SQL Server functions SUSER_NAME() and SUSER_SNAME() both return the current login name. So why are there two? Read on to find out what the difference is.

  [more…]

• Prevent unauthorized REVERTing after EXECUTE AS

  

  2014-01-10 - General, Security

  Worried about unauthorized REVERTing after using EXECUTE AS? Read on to get all the details about EXECUTE AS WITH NO REVERT and EXECUTE AS WITH COOKIE.

  [more…]

• 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…]