Tag: security management

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

• ALL PRIVILEGES – The Misleading Permissions Shortcut

  

  2014-01-28 - General, Security, Security Misconceptions

  GRANT ALL PRIVILEGES suggest it will grant all applicable privileges on a securable to a principal. However, in most RDBMSs including SQL Server this is not actually the case. In addition, this feature has been deprecated. Read on to get all the details.

  [more…]

• How to use Column Level Permissions for Fine-Grained Permission Management

  

  2014-01-27 - General, Security

  Column level permissions allow us even more fine-grained control over data access privileges. A simple extension to the GRANT statement makes this possible. Read on to get all the details.

  [more…]