[MXS-139] Schemarouter authentication for wildcard grants fails without optimize_wildcard Created: 2015-05-14  Updated: 2015-06-02  Resolved: 2015-05-14

Status: Closed
Project: MariaDB MaxScale
Component/s: schemarouter
Affects Version/s: 1.1.0
Fix Version/s: 1.2.0

Type: Bug Priority: Major
Reporter: markus makela Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None


 Description   

Database level authentication fails with the schemarouter when users are given wildcard grants against databases.

Example grant:
GRANT ALL PRIVILEGES ON `database%`.* to `user`@`IP`

This would fail without the optimize_wildcard option if the user logged in directly to the database.



 Comments   
Comment by markus makela [ 2015-05-14 ]

Removed database level authentication from multi-server authentication on the basis that it is highly likely all databases do not exist on all the servers. This change was done with sharded environments in mind where not all servers share the same users or grants to the users.

Comment by markus makela [ 2015-06-02 ]

Wildcard database names now work properly.

Generated at Thu Feb 08 03:57:05 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.