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

Bind REPLICATION SLAVE ADMIN to a number of global system variables

Details

    Description

      SET for the following slave related system GLOBAL-only variables:

      • init_slave
      • replicate_events_marked_for_skip
      • replicate_do_db
      • replicate_do_table
      • replicate_ignore_db
      • replicate_ignore_table
      • replicate_wild_do_table
      • replicate_wild_ignore_table
      • read_binlog_speed_limit
      • slave_compressed_protocol
      • slave_ddl_exec_mode
      • slave_domain_parallel_threads
      • slave_exec_mode
      • slave_max_allowed_packet
      • slave_net_timeout
      • slave_parallel_max_queued
      • slave_parallel_mode
      • slave_parallel_threads
      • slave_parallel_workers
      • slave_run_triggers_for_rbr
      • slave_sql_verify_checksum
      • slave_transaction_retry_interval
      • slave_type_conversions

      is allowed only for users with the SUPER privilege as of 10.5.1.

      Let's allow SET for these global variables also for users with the REPLICATION SLAVE ADMIN privilege.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-21743 Split up SUPER privilege to smaller privileges

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

          Task - A task that needs to be done. MDEV-22026 Document 10.5 privilege changes

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            bar Alexander Barkov created issue -
            bar Alexander Barkov made changes -
            Field Original Value New Value
            bar Alexander Barkov made changes -
            Summary Bind SLAVE ADMIN to a number of global system variables Bind REPLICATION SLAVE ADMIN to a number of global system variables
            bar Alexander Barkov made changes -
            Description SET for the following slave related system GLOBAL-only variables:

            - init_slave
            - replicate_events_marked_for_skip
            - replicate_do_db
            - replicate_do_table
            - replicate_ignore_db
            - replicate_ignore_table
            - replicate_wild_do_table
            - replicate_wild_ignore_table
            - read_binlog_speed_limit
            - slave_compressed_protocol
            - slave_ddl_exec_mode
            - slave_domain_parallel_threads
            - slave_exec_mode
            - slave_max_allowed_packet
            - slave_net_timeout
            - slave_parallel_max_queued
            - slave_parallel_mode
            - slave_parallel_threads
            - slave_parallel_workers
            - slave_run_triggers_for_rbr
            - slave_sql_verify_checksum
            - slave_transaction_retry_interval
            - slave_type_conversions

            is allowed only for users with the SUPER privilege as of 10.5.1.

            Let's allow SET for these global variables also for users with the SLAVE ADMIN privilege.
            		SET for the following slave related system GLOBAL-only variables:

            - init_slave
            - replicate_events_marked_for_skip
            - replicate_do_db
            - replicate_do_table
            - replicate_ignore_db
            - replicate_ignore_table
            - replicate_wild_do_table
            - replicate_wild_ignore_table
            - read_binlog_speed_limit
            - slave_compressed_protocol
            - slave_ddl_exec_mode
            - slave_domain_parallel_threads
            - slave_exec_mode
            - slave_max_allowed_packet
            - slave_net_timeout
            - slave_parallel_max_queued
            - slave_parallel_mode
            - slave_parallel_threads
            - slave_parallel_workers
            - slave_run_triggers_for_rbr
            - slave_sql_verify_checksum
            - slave_transaction_retry_interval
            - slave_type_conversions

            is allowed only for users with the SUPER privilege as of 10.5.1.

            Let's allow SET for these global variables also for users with the REPLICATION SLAVE ADMIN privilege.
            bar Alexander Barkov made changes -
            issue.field.resolutiondate 2020-03-18 03:33:02.0 2020-03-18 03:33:02.393
            bar Alexander Barkov made changes -
            Fix Version/s 10.5.2 [ 24030 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            bar Alexander Barkov made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 104982 ] MariaDB v4 [ 134211 ]

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.