[MXS-3343] Escape characters in grants on schemas are not removed leading to access denied Created: 2020-12-17 Updated: 2020-12-17 Resolved: 2020-12-17 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | Authenticator |
| Affects Version/s: | 2.5.5 |
| Fix Version/s: | 2.5.6 |
| Type: | Task | Priority: | Major |
| Reporter: | Claudio Nanni | Assignee: | Esa Korhonen |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Description |
|
A grant on a schema containing an underscore has to be specified using the escape \ GRANT SELECT ON 'schema\ _name' TO ... MaxScale treats the backslash as literal so not recognizing the proper schema name. This leads to access denied whenever the schema is provided upon connection. Please note MariaDB docs lack of the part dealing with wildcards, filing a separate bug for that. |
| Comments |
| Comment by Esa Korhonen [ 2020-12-17 ] |