Do the users initiating inserts on the master server also have to be on the slave with at least as many permissions for the replicated queries to be correctly executed? My understanding is that you only have to have a replication user with enough permissions but I still have a doubt.
Moreover, let's say that the slave server has the same users as the master server, in addition to a replication-dedicated user, but with less permissions, non writes for instance. Would there be any kind of conflicts resulting in the replicated queries not being executed?
The idea is to have a read-only slave with only
SELECT perm users to access to data, not necessarily the same as the master's users, plus a replication-dedicated user on the slave with
REPLICATION SLAVE perm. Would all replicated queries then supposed to be executed normally? That's my actual wondering.