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

Bind BINLOG ADMIN to a number of global system variables

    XMLWordPrintable

    Details

      Description

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

      • binlog_cache_size GLOBAL - add BINLOG ADMIN
      • binlog_file_cache_size GLOBAL - add BINLOG ADMIN
      • binlog_stmt_cache_size GLOBAL - add BINLOG ADMIN
      • binlog_commit_wait_count GLOBAL - add BINLOG ADMIN
      • binlog_commit_wait_usec GLOBAL - add BINLOG ADMIN
      • binlog_row_metadata GLOBAL - add BINLOG ADMIN
      • expire_logs_days GLOBAL - add BINLOG ADMIN
      • log_bin_compress GLOBAL - add BINLOG ADMIN
      • log_bin_compress_min_len GLOBAL - add BINLOG ADMIN
      • log_bin_trust_function_creators GLOBAL - add BINLOG ADMIN
      • max_binlog_cache_size GLOBAL - add BINLOG ADMIN
      • max_binlog_stmt_cache_size GLOBAL - add BINLOG ADMIN
      • max_binlog_size GLOBAL - add BINLOG ADMIN
      • sync_binlog GLOBAL - add BINLOG ADMIN

      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 BINLOG 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: