[MDEV-22026] Document 10.5 privilege changes Created: 2020-03-24  Updated: 2020-03-30  Resolved: 2020-03-30

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

Type: Task Priority: Major
Reporter: Alexander Barkov Assignee: Kenneth Dyer (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Attachments: HTML File privilege-10.5.2.html    
Issue Links:
Relates
relates to MDEV-21743 Split up SUPER privilege to smaller p... Closed
relates to MDEV-21957 Bind BINLOG ADMIN to @@binlog_format,... Closed
relates to MDEV-21960 Bind READ_ONLY ADMIN to @@read_only Closed
relates to MDEV-21961 Bind CONNECTION ADMIN to a number of ... Closed
relates to MDEV-21963 Bind BINLOG ADMIN to a number of glob... Closed
relates to MDEV-21966 Bind REPLICATION SLAVE ADMIN to a num... Closed
relates to MDEV-21967 Bind REPLICATION {MASTER|SLAVE} ADMIN... Closed
relates to MDEV-21969 Bind REPLICATION SLAVE ADMIN to relay... Closed
relates to MDEV-21971 Bind BINLOG ADMIN to binlog_annotate_... Closed
relates to MDEV-21972 Bind REPLICATION MASTER ADMIN to mast... Closed
relates to MDEV-21973 Bind REPLICATION {MASTER|SLAVE} ADMIN... Closed
relates to MDEV-21975 Add BINLOG REPLAY privilege and bind ... Closed
relates to MDEV-22012 Allow SET TIMESTAMP for users with GR... Closed
relates to MDEV-22030 Don't grant REPLICATION MASTER ADMIN ... Closed

 Description   

Let's document the changes in the privilege system made in 10.5.2.

Summary

MDEV-21743 (and a number of related tasks, liked to this task) made the following changes:

  • Added new privileges:
    • SET USER
    • FEDERATED ADMIN
    • CONNECTION ADMIN
    • READ_ONLY ADMIN
    • REPLICATION SLAVE ADMIN
    • REPLICATION MASTER ADMIN
    • BINLOG_ADMIN
    • BINLOG_REPLAY
  • Renamed the REPLICATION CLIENT privilege to BINLOG MONITOR. The old syntax is still understood for compatibility.
  • Renamed the SHOW MASTER STATUS statement to SHOW BINLOG STATUS. The old syntax is still understood for compatibility.
  • Modified privileges required for the following statements:
    • SHOW BINLOG EVENTS
    • SHOW SLAVE HOSTS
    • SHOW SLAVE STATUS
    • SHOW RELAYLOG EVENTS

Please see the attached HTML file for details.

 Comments   
Comment by Sergei Golubchik [ 2020-03-30 ]

https://mariadb.com/kb/en/grant/#global-privileges

Generated at Thu Feb 08 09:11:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.