Tag: GRANT

• How to REVOKE just the GRANT OPTION

  

  2014-02-05 - General, Security

  To remove just the grant option from a permission that has been granted specifying WITH GRANT OPTION , the REVOKE GRANT OPTION statement can be used. Read on to get all the details.

  [more…]

• How to REVOKE a GRANT … WITH GRANT OPTION

  

  2014-02-04 - General, Security

  When revoking a permission that was granted with the WITH GRANT OPTION, you cannot just revoke the privilege itself. Instead SQL Server forces us to remove all permissions that were granted based on it too. Read on to see how this might impact your permission management.

  [more…]

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