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

SHOW GRANTS FOR does not work for a user identified with non-existing plugin

    XMLWordPrintable

    Details

      Description

      INSTALL SONAME 'auth_socket';
      CREATE USER foo IDENTIFIED WITH unix_socket;
      SHOW GRANTS FOR foo;
      UNINSTALL SONAME 'auth_socket';
      FLUSH PRIVILEGES;
      SHOW GRANTS FOR foo;
       
      # Cleanup
      DROP USER foo;
      

      10.4 fac997feef

      MariaDB [test]> SHOW GRANTS FOR foo;
      ERROR 1141 (42000): There is no such grant defined for user 'foo' on host '%'
      

      On 10.3 the grants are still shown, and I think it makes more sense.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              elenst Elena Stepanova
              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.