Tag: security

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

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

• Using Server Roles for Server Level Security Management

  

  2014-01-04 - General, Security

  Server roles simplify management of server level permissions. Before SQL Server 2012 we were confined to 9 fixed server roles. However, now we are able to create user-defined server roles and grant any server level permission to them. Read on to find out more…

  [more…]