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

Inconsistent output of SHOW CREATE USER and SHOW GRANTS for users with TLS options

    XMLWordPrintable

    Details

      Description

      When a TLS option is defined for a user, SHOW CREATE USER and SHOW GRANTS shows CIPHER '' in addition to the defined option(s); but it only happens after FLUSH PRIVILEGES.

      CREATE USER foo REQUIRE ISSUER 'bar';
      SHOW GRANTS FOR foo;
      SHOW CREATE USER foo;
      FLUSH PRIVILEGES;
      SHOW GRANTS FOR foo;
      SHOW CREATE USER foo;
       
      # Cleanup
      DROP USER foo;
      

      10.4 e7924a8598

      SHOW GRANTS FOR foo;
      Grants for foo@%
      GRANT USAGE ON *.* TO 'foo'@'%' REQUIRE ISSUER 'bar'
      SHOW CREATE USER foo;
      CREATE USER for foo@%
      CREATE USER 'foo'@'%' REQUIRE ISSUER 'bar'
      FLUSH PRIVILEGES;
      SHOW GRANTS FOR foo;
      Grants for foo@%
      GRANT USAGE ON *.* TO 'foo'@'%' REQUIRE ISSUER 'bar' CIPHER ''
      SHOW CREATE USER foo;
      CREATE USER for foo@%
      CREATE USER 'foo'@'%' REQUIRE ISSUER 'bar' CIPHER ''
      DROP USER foo;
      

        Attachments

          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