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

Remove requirement for SUPER in order to manipulate replication

    XMLWordPrintable

Details

    Description

      The STOP SLAVE and related commands require SUPER.
      We require finer-grained access rights.

      From MySQL 8.0 docs:
      https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_replication-slave-admin :

      REPLICATION_SLAVE_ADMIN

      Enables the account to connect to the master server, start and stop replication, and use the CHANGE MASTER TO and CHANGE REPLICATION FILTER statements. Grant this privilege to accounts that are used by slave servers to connect to the current server as their master. This privilege does not apply to Group Replication; use GROUP_REPLICATION_ADMIN for that.

      Attachments

        Activity

          People

            Unassigned Unassigned
            Eric_Herman Eric Herman
            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.