Tag: Permission

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

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

• Member Management for Database Roles

  

  2014-01-07 - Fundamentals, General, Security

  Database roles can greatly simplify permission management on a database level. Learn how to add and remove members and how to retrieve the list of all current members of a database role.

  [more…]

• Using Database Roles for Database Level Security Management

  

  2014-01-06 - Fundamentals, General, Security

  Database roles simplify security management on a database level. With database roles we can grant or deny permissions to a group of database users. Find out how you can use database roles in your environment.

  [more…]