Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL)
-
None
-
10.1.10
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.
Attachments
Issue Links
- relates to
-
MDEV-5164 Testing Roles
- Closed