If a user holds a privilege with grant option and has granted it to
   other users then the privileges held by those other users are
   called dependent privileges. If the privilege or the grant option
   held by the first user is being revoked and dependent privileges
   exist, those dependent privileges are also revoked if
   <code class="literal">CASCADE</code> is specified; if it is not, the revoke action
   will fail.  This recursive revocation only affects privileges that
   were granted through a cha