Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-872

MaxScale doesn't understand roles

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.0.1
    • 2.2.10
    • Core
    • 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

      1. 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'@'%';
        

      2. Start MaxScale with any configuration that uses the master where the SQL was executed
      3. 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

          Activity

            People

              markus makela markus makela
              markus makela markus makela
              Votes:
              2 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.