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

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

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

          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

            Ascending order - Click to sort in descending order
            bar Alexander Barkov created issue -
            bar Alexander Barkov made changes -
            Field Original Value New Value
            bar Alexander Barkov made changes -
            Description SET for 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.
            		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.
            bar Alexander Barkov made changes -
            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.
            		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.
            bar Alexander Barkov made changes -
            issue.field.resolutiondate 2020-03-17 07:32:31.0 2020-03-17 07:32:31.289
            bar Alexander Barkov made changes -
            Fix Version/s 10.5.2 [ 24030 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            bar Alexander Barkov made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 104928 ] MariaDB v4 [ 134206 ]

            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.