Tag: security

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

• How to Interpret Misleading Error Messages related to the GRANT statement

  

  2014-01-29 - General, Security

  SQL Server error messages can sometimes be misleading. One example is the error returned when trying to GRANT permissions without holding appropriate permissions yourself. Read on to see how to deal with this and other ambiguous error messages.

  [more…]