Cascading REVOKE not working in MYSQL I've read about an SQL option of cascading permissions when issuing a REVOKE statement. I've googled for how this option is implemented in MySQL, but haven't found it at all. 

This is the docs page about the REVOKE syntax and there is no sign of cascading option.

The SQL standard cascade syntax has the following format:

REVOKE [GRANT OPTION FOR] privileges ON object FROM user {RESTRICT | CASCADE}


Is it possible to cascade permissions revoking in MySQL?
Neither MySQL, nor Mariadb (https://mariadb.com/kb/en/library/revoke/), has implemented RESTRICT or CASCADE.

In general, a REVOKE can negate only an identical GRANT.  You cannot, for example, GRANT ALL ..., then REVOKE UPDATE ....

That is, the GRANT/REVOKE feature of MySQL and MariaDB is quite limited.

"Roles" are available in MySQL 8.0 and MariaDB 10.0.  (But I don't think that is relevant to your question.)


  Syntax naturally differs a little from dbms to dbms.


Change "a little" to "sometimes a lot".