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

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18290 Users identified via ed25519 are broken after upgrade to 10.4

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is caused by

          Task - A task that needs to be done. MDEV-12321 authentication plugin: SET PASSWORD support

          • Major - Major loss of function.
          • Closed

            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.