Bug #69313 | REVOKE ALLPRIVILEGES, GRANT OPTION ON db.* FROM user@host is a syntax error | ||
---|---|---|---|
Submitted: | 24 May 2013 15:09 | Modified: | 16 Jun 2013 20:22 |
Reporter: | Mathieu Lemoine | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Parser | Severity: | S3 (Non-critical) |
Version: | 5.5.30 | OS: | Linux (Ubuntu 13.04) |
Assigned to: | CPU Architecture: | Any |
[24 May 2013 15:09]
Mathieu Lemoine
[25 May 2013 20:26]
MySQL Verification Team
Thank you for the bug report. http://dev.mysql.com/doc/refman/5.5/en/revoke.html "To revoke all privileges, use the second syntax, which drops all global, database, table, column, and routine privileges for the named user or users: REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ..." So: revoke all privileges, grant option on `db`.* from 'user'@'host' ; ˆˆˆˆˆˆˆˆˆ It's a syntax error.
[16 Jun 2013 20:22]
Mathieu Lemoine
Hello, Yes, I know it is. And that's my point: it should not be. It's inconsistent and weird that we can do revoke all privileges, grant option from 'user'@'host' ; but not revoke all privileges, grant option on `db`.* from 'user'@'host' ; Especially since the restriction doesn't apply to the GRANT statement.