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

SHOW GRANTS does not work for a replicated role (throws 'There is no such grant defined for user ...')

        Details

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

          Description

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

--enable_connect_log

create user u1;
create role r1;
--echo #
--echo # On master SHOW GRANTS work both for the user and the role:
show grants for u1;
show grants for r1;
--echo #
--sync_slave_with_master
--echo #
--echo # The role has been replicated, 
--echo # it's visible in mysql.user and I_S:
--echo #
select user, host, is_role from mysql.user;
select * from information_schema.applicable_roles;
--echo #
--disable_abort_on_error
--echo #
--echo # For the new user, SHOW GRANTS works:
show grants for u1;
--echo #
--echo # But for the new role, it does not:
show grants for r1;
--echo #
--echo # FLUSH PRIVILEGES does not help:
flush privileges;
show grants for r1;
--echo #
--echo # The role can be set, but SHOW GRANTS for it still does not work:
set role r1;
show grants for r1;
--echo #
--echo # However, in the user's SHOW GRANTS it's visible
show grants;

          Printed comments in the test case pretty much describe it all. I create a role on the master, wait till it's replicated to the slave, but SHOW GRANTS FOR <this role> does not work, even though otherwise it appears to be fine.

          Not reproducible on 10.0.

            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:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated: