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

Escape characters in grants on schemas are not removed leading to access denied

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 2.5.5
    • 2.5.6
    • Authenticator
    • 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.

      Attachments

        Activity

          People

            esa.korhonen Esa Korhonen
            claudio.nanni Claudio Nanni
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.