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

Bind BINLOG ADMIN to @@binlog_format, @@binlog_direct_.., @@sql_log_bin

    XMLWordPrintable

Details

    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.

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.