[MDEV-30735] "REVOKE privilege(s), GRANT OPTION ON ... TO ..." is not possible Created: 2023-02-27 Updated: 2023-02-27 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Authentication and Privilege System |
| Fix Version/s: | None |
| Type: | Task | Priority: | Trivial |
| Reporter: | Jean Weisbuch | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
It is possible to give the GRANT OPTION privilege to a user on a specific database or table along with other privileges on a single statement but not to REVOKE them the same way. For example, it is possible to GRANT those in a single statement :
But two statements are required to REVOKE :
The single statement REVOKE is only possible for GRANT OPTION that are server-wide but not limited to a database or a table, such as :
— A similar syntax for database/tables would be more consistent, for example :
While it's not consistent with the GRANT which requires the WITH GRANT OPTION at the end of the statement, it would still be more consistent than having to use two different statements. |