DENY will fail if CASCADE is not specified when denying permission to a principal that was granted that permission with GRANT OPTION specified.

• 如果某主体的该权限是通过指定GRANT OPTION获得的,那么,在撤消其该权限时,如果未指定CASCADE,则DENY将失败。