Tag: REVOKE CASCADE

• Permission Delegation Done Right – Role Based Delegation

  

  2014-02-18 - General, Security

  Role base permission management can make permission management and permission management delegation a lot simpler. Read on to see how roles can be used to make grantable grants obsolete.

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

• REVOKE CASCADE does not work on CONTROL permission

  

  2014-02-07 - General, Security, Security Pitfalls

  REVOKE together with the CASCADE keyword removes a permission and also all child permissions that were granted based on it. Read on to see how this plays out if the permission in question is the CONTROL privilege.

  [more…]

• REVOKE CASCADE: Revoking an Entire Grant Hierarchy

  

  2014-02-06 - General, Security

  Does the CASCADE keyword on the REVOKE statement imply that you can build an entire hierarchy of grantable grants using GRANT … WITH GRANT OPTION? What does that mean for your permission management plan? Find out now.

  [more…]

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