Tag: server principals

• How to GRANT Permissions in T-SQL

  

  2014-01-24 - General, Security

  The T-SQL GRANT statement is a surprisingly complex statement that can be used to control fine grained permissions. In its basic form is has three sections that answer the questions What?, Where? and Who?. 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…]

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

• Member Management for Server Roles

  

  2014-01-05 - General, Security

  Server Roles allow for simplified security management for server level permissions in SQL Server. Learn how to add new members, remove existing ones or list all current members of a server role. [more…]