Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9580

SHOW GRANTS FOR <current_user> fails

    XMLWordPrintable

Details

    • 10.0.25

    Description

      If <user> does not have SELECT privilege on the `mysql` database and <user> is the current user the "SHOW GRANTS FOR <user>" (without hostname specified) statement fails with:

      1044: Access denied for user '<user>'@'%' to database 'mysql'

      This can be reproduced with the following test:

      CREATE USER test;
      connect (conn_1, localhost, test,,);
      SHOW GRANTS FOR test;

      This worked in 10.0.12, and seems to have been broken as part of the fix for MDEV-6625.

      Attachments

        Activity

          People

            serg Sergei Golubchik
            davidgow David Gow
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.