Tag: DENY

• How to identify active database permissions using sys.database_permissions

  

  2014-02-22 - DMVs & CVs, General, Security, Security

  The sys.database_permissions catalog view can be used to identify active database permissions that are defined in the current database. Read on to find out how to interpret the output of this catalog view.

  [more…]

• The Unexpected Side Effect of DENY CONTROL

  

  2014-02-21 - General, Security, Security Pitfalls

  Denying a powerful privilege like CONTROL can have unforeseen side effects. Read on to see how using DENY CONTROL can render an entire security principal unusable.

  [more…]

• Security Pitfalls – Column Level GRANT overrides Table Level DENY

  

  2014-02-20 - General, Security, Security Pitfalls

  While a DENY on one level of a security hierarchy in SQL Server always overrides a GRANT on a different level, there is one important exception. Read on to learn more about this exception and how it affects your security management.

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

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