0

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?

  • What version of MySQL are you using? Please provide the URL for that quote. – Rick James Sep 7 at 18:37
  • I am on 10.1.38-MariaDB. database management systems, 3ed, Johannes Gehrke and Raghu Ramakrishnan, page 699. Syntax naturally differs a little from dbms to dbms.. I put it up just for reference and to better explain what I am searching. – sanjihan Sep 7 at 21:25
0

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".

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.