Category: General

• Permission Delegation Done Right – Role Based Delegation

  

  2014-02-18 - General, Security

  Role base permission management can make permission management and permission management delegation a lot simpler. Read on to see how roles can be used to make grantable grants obsolete.

  [more…]

• Permission Delegation Done Right – Preventing Cascading Revokes

  

  2014-02-17 - General, Security

  Grantable grant are an easy way to delegate permission management. However, revoking a grantable grant can cause trouble. Read on to see how using roles in conjunction with grantable grants can alleviate that problem.

  [more…]

• DENY CASCADE does not CASCADE the DENY

  

  2014-02-16 - General, Security, Security Pitfalls

  What the DENY CASCADE statement does seems obvious. But is it? Read on to see what DENY CASCADE actually does and if that matches your expectation.

  [more…]

• How to undo a DENY

  

  2014-02-15 - General, Security

  Undoing a DENY that has become obsolete is actually quite simple. Read on to see how you can remove a DENY the same way you would remove a GRANT.

  [more…]

• DENY vs. REVOKE – Part 5 – Durability

  

  2014-02-14 - DENY vs. REVOKE, General, Security, Series

  A DENY is a durable permission, similar to a GRANT. Find out what that means and how it affects your SQL Server permissions management.

  [more…]