The REVOKE statement will fail if CASCADE is not specified when you are revoking a permission from a principal that was granted that permission with GRANT OPTION specified.

• 在撤消通过指定GRANT OPTION为其赋予权限的主体的权限时,如果未指定CASCADE,则将无法成功执行REVOKE语句。