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

Bind REPLICATION SLAVE ADMIN to a number of global system variables

    XMLWordPrintable

    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

              People

              Assignee:
              bar Alexander Barkov
              Reporter:
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: