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

bugzillaId-719: mandatory SELECT privilege on db level?

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.0.4
    • 1.4.0
    • Core
    • None
    • Linux
    • 2016-3

    Description

      This is imported from bugzilla item: http://bugs.mariadb.com/show_bug.cgi?id=719

      Description lisu87 2015-02-04 09:30:00 UTC
      After upgrading from 1.0.1beta to 1.0.4 GA we found out we cannot longer use maxscale with mysql users which have SELECT privilege on table level.

      When trying to connect to mysql server via maxscale without specifying default db it works, but with default db specified we always get "Access denied for user".

      The solution that worked for us was to grant SELECT privilege for user on db level instead of doing so for specific tables in the database.

      Please let me know if this behaviour is intended?

      Attachments

        Activity

          People

            markus makela markus makela
            lisu87 lisu87
            Votes:
            0 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.