The account you create for MQM to use will have syadmin as a role and dbo permissions on the database. It will have both read and write access. It should have full permission to the MQM database.
my DBA team refused to give my user sysadmin role, so i have experienced that:
- once created an empty database by a DBA, database-level role db_ddladmin is sufficient for user to create database schema
- once created schema, database-level role db_datawriter and db_datareader are sufficient for user