[MDEV-21973] Bind REPLICATION {MASTER|SLAVE} ADMIN to gtid_* GLOBAL-only system variables Created: 2020-03-18  Updated: 2020-03-24  Resolved: 2020-03-18

Status: Closed
Project: MariaDB Server
Component/s: Replication
Fix Version/s: 10.5.2

Type: Task Priority: Major
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-21743 Split up SUPER privilege to smaller p... Closed
relates to MDEV-22026 Document 10.5 privilege changes Closed

 Description   

Let's bind GLOBAL-only gtid_* system variables to the recently added privileges as follows:

Name                     Scope           New GLOBAL privilege
 
----                     -------------   ---------------------------------
 
gtid_binlog_state        GLOBAL          SUPER or REPLICATION MASTER ADMIN
 
gtid_cleanup_batch_size  GLOBAL          SUPER or REPLICATION SLAVE ADMIN
 
gtid_ignore_duplicates   GLOBAL          SUPER or REPLICATION SLAVE ADMIN
 
gtid_pos_auto_engines    GLOBAL          SUPER or REPLICATION SLAVE ADMIN
 
gtid_slave_pos           GLOBAL          SUPER or REPLICATION SLAVE ADMIN
 
gtid_strict_mode         GLOBAL          SUPER or REPLICATION SLAVE ADMIN

As of version 10.5.1, a SET command for these global variables required the SUPER privilege.
Generated at Thu Feb 08 09:11:14 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.