Bug #90133 | GRANT on particular table where database has an escape character is not allowed | ||
---|---|---|---|
Submitted: | 20 Mar 2018 1:37 | Modified: | 22 Mar 2018 22:15 |
Reporter: | Jaime Sicam | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: Security: Privileges | Severity: | S3 (Non-critical) |
Version: | 5.7.21 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[20 Mar 2018 1:37]
Jaime Sicam
[22 Mar 2018 22:15]
MySQL Verification Team
Hi, can't be 100% what's "expected" but I can say that your observation is accurate and that wildcards _ and % are not working in the database name for GRANT while our documentation here: https://dev.mysql.com/doc/refman/5.7/en/grant.html directly states that [quote] The _ and % wildcards are permitted when specifying database names in GRANT statements that grant privileges at the database level. This means, for example, that to use a _ character as part of a database name, specify it as \_ in the GRANT statement, to prevent the user from being able to access additional databases matching the wildcard pattern; for example, GRANT ... ON `foo\_bar`.* TO ... [/quote] This is a duplicate of bug #88694 and bug #87420 all best Bogdan