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

REVOKE ALL PRIVILEGES, GRANT OPTION FROM CURRENT_ROLE breaks replication

        Details

        • Type: Bug
        • Status: Open
        • Priority: Major
        • Resolution: Unresolved
        • Affects Version/s: 10.1, 10.0
        • Fix Version/s: 10.1, 10.0
        • Component/s: Admin statements, Replication
        • Labels:
          None

          Description

          Replication has some magic that (normally) allows to work correctly with such functions as CURRENT_USER and CURRENT_ROLE (see MDEV-8628, MDEV-8631). However, for REVOKE ALL PRIVILEGES, GRANT OPTION FROM CURRENT_ROLE this magic fails.

          Test case
          --source include/master-slave.inc
--source include/have_binlog_format_mixed.inc

--enable_connect_log

create role r1;
set role r1;
grant select on db.* to current_role;
revoke all privileges, grant option from current_role;

--sync_slave_with_master

          Last_SQL_Errno	1269
Last_SQL_Error	Error 'Can't revoke all privileges for one or more of the requested users' on query. Default database: 'test'. Query: 'revoke all privileges, grant option from current_role'

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Task - A task that needs to be done. MDEV-5164 Testing Roles

                • Major - Major loss of function.
                • Stalled

                  Activity

                  There are no comments yet on this issue.

                    People

                    • Assignee:
                      cvicentiu Vicentiu Ciorbaru
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      1 Start watching this issue

                      Dates

                      • Created:
                        Updated: