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

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 2.5.5
    • Fix Version/s: 2.5.6
    • Component/s: Authenticator
    • Labels:
      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

            Assignee:
            esa.korhonen Esa Korhonen
            Reporter:
            claudio.nanni Claudio Nanni (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: