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

SHOW GRANTS FOR <current_user> fails

    XMLWordPrintable

    Details

    • Sprint:
      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

            Assignee:
            serg Sergei Golubchik
            Reporter:
            davidgow David Gow
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: