[MDEV-30537] Feature request : REVOKE IF EXISTS / REVOKE ... IGNORE UNKNOWN USER Created: 2023-02-01 Updated: 2023-02-27 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Jean Weisbuch | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
MySQL 8 has support for "REVOKE IF EXISTS" and also for "REVOKE ... IGNORE UNKNOWN USER" which are not available on MariaDB. |
| Comments |
| Comment by Sergei Golubchik [ 2023-02-24 ] | ||
|
REVOKE IF EXISTS makes a lot of sense. We had On the other hand, IGNORE UNKNOWN USER looks strange, not consistent with existing syntax. I'd prefer to use IF EXISTS too. Like
This isn't very English, FROM foo@bar IF EXISTS would look better.
| ||
| Comment by Jean Weisbuch [ 2023-02-27 ] | ||
|
I don't think the FROM IF EXISTS (and IGNORE UNKNOWN USER) has much usefulness on a REVOKE IF EXISTS statement as the privilege(s) could not exist (and thus, be removed) if the user doesn't, it could simply throw the same warning if the privilege(s) and/or user doesn't exist. |