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
 
-