Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.0.1
-
None
-
MXS-SPRINT-60
Description
When a user is assigned a role which grants access to a specific database, MaxScale will refuse to grant access for that user.
Steps to reproduce
- Execute following SQL on master
CREATE DATABASE my_db;
CREATE ROLE dba;
GRANT SELECT ON my_db.* TO dba;
CREATE USER 'test'@'%' IDENTIFIED BY 'test';
SET DEFAULT ROLE dba FOR 'test'@'%';
- Start MaxScale with any configuration that uses the master where the SQL was executed
- Connect to MaxScale as 'test'@'%' with the default database my_db
mysql -u test -ptest -h $maxscale_host -P $maxscale_port -D my_db
Attachments
Issue Links
- relates to
-
MXS-2544 PAMAuth doesn't check role permissions
- Closed