Category: General

• Security Pitfalls – Revoking Column Permissions

  

  2014-02-03 - General, Security, Security Pitfalls

  A REVOKE always removes only an exactly alike GRANT. However there is one important exception: The handling of column permissions follows its own rules. Read on to get all the details.

  [more…]

• REVOKE: How to Undo Granted Permissions

  

  2014-02-02 - General, Security

  If you have a security principal with a specific permission and you want to remove that permission from that principal, you can use the REVOKE statement. Read on to get all the details on how to use it.

  [more…]

• Database Level Object Permissions – Should you use them?

  

  2014-02-01 - General, Security

  Database level object permissions (object access privileges granted on the database) can significantly simplify permission management. But should you use them? Read on to find out.

  [more…]

• Using SQL Server Schema Permissions to Simplify Permission Management

  

  2014-01-31 - General, Security

  In SQL Server Schemata can significantly simplify permission management. Read on to find out how you can use schema permissions that extend automatically to all objects in that schema.

  [more…]

• Is Granting on All Columns Really the Same as Granting on the Table Itself?

  

  2014-01-30 - General, Security, Security Misconceptions

  Permissions on a table level and permissions granted to all columns on that table appear identical at first. However there actually is a big difference. Read on to find out all about it.

  [more…]