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

SUPER has monitor privileges but they are not added to pre-10.5 SUPER users

    XMLWordPrintable

    Details

      Description

      Upon upgrade from pre-10.5 versions SUPER users are given explicit privileges which SUPER alias includes, apparently for future deprecation of the alias.

      However, not all of them are added. SUPER also includes BINLOG_MONITOR and SLAVE_MONITOR privileges, but they are not added to the users with SUPER.

      10.5 fb70bb44

      MariaDB [(none)]> show slave status;
      Empty set (0.000 sec)
       
      MariaDB [(none)]> show grants;
      +-------------------------------------------------------------------------------------------------------------------------------------------------------+
      | Grants for super@%                                                                                                                                    |
      +-------------------------------------------------------------------------------------------------------------------------------------------------------+
      | GRANT SUPER, SET USER, FEDERATED ADMIN, CONNECTION ADMIN, READ_ONLY ADMIN, REPLICATION SLAVE ADMIN, BINLOG ADMIN, BINLOG REPLAY ON *.* TO `super`@`%` |
      +-------------------------------------------------------------------------------------------------------------------------------------------------------+
      1 row in set (0.000 sec)
       
      MariaDB [(none)]> show slave status;
      Empty set (0.000 sec)
      

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.