[MDEV-30582] GRANT replication from 10.x to 11.x Created: 2023-02-06  Updated: 2023-02-06

Status: Open
Project: MariaDB Server
Component/s: Authentication and Privilege System, Replication
Affects Version/s: 11.0
Fix Version/s: 11.0

Type: Bug Priority: Minor
Reporter: Sergei Golubchik Assignee: Sergei Golubchik
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-29668 SUPER should not allow actions that h... Closed

 Description   

After MDEV-29668, SUPER privilege won't allow many activities that it was allowing before.
Upgrades are handled by the server, a user having SUPER will have all necessary privileges after upgrade to 11.0 to continue doing what he was able to do before.

But replication isn't, if someone is granted SUPER, he'll be able to do much more on the 10.x master than on the 11.0 slave. This could potentially break replication if that user will do something that he can on the master, but not on the slave, and this statement is replicated. For example, CREATE DEFINER=xxx VIEW.


Generated at Thu Feb 08 10:17:20 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.