[MDEV-21957] Bind BINLOG ADMIN to @@binlog_format, @@binlog_direct_.., @@sql_log_bin Created: 2020-03-17  Updated: 2020-03-24  Resolved: 2020-03-17

Status: Closed
Project: MariaDB Server
Component/s: Variables
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   

SET for the following system variables (both GLOBAL and SESSION):

  • binlog_format
  • binlog_direct_non_transactional_updates
  • sql_log_bin

has been allowed only for users with the SUPER privilege.

Let's allow SET for these variables (both GLOBAL and SESSION) also for users with the BINLOG ADMIN privilege.

Note, sql_log_bin is actually a SESSION-only variable (since MariaDB 5.5). However, internally it is still defined as a GLOBAL-and-SESSION variable, while setting the global one is forbidden by non-standard means.
Generated at Thu Feb 08 09:11:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.