If you enable granular permissions, and then manually configure the maintenance user permissions, you see an error message when you use the rs_init interactive mode to add a database to the replication system.
Sending the following SQL command to the server: 'sp_role "grant", replication_role, <maintenance user name>'. SQL Server message: msg 10331, level 14, state 2 WARNING: "Permission denied, database master, owner dbo. You need the following permission(s) to run this command: MANAGE ROLES."Since you have manually granted the required permissions to the maintenance user IDs, ignore the error message and press the Enter key to continue.