Database Logins, Users, and Roles (Master Data Services)
Master Data Services includes logins, users, and roles that are automatically installed on the SQL Server Database Engine instance that hosts the Master Data Services database. These logins, users, and roles should not be modified.
Allows creation of UNSAFE assemblies. For more information, see Creating an Assembly.
Enabled login used for notifications.
For msdb and the Master Data Services database, mds_email_user maps to this login.
Used for notifications.
Owns the mdm and mdq schemas. The default schema is mdm.
Does not have a login mapped to it.
Used to execute Service Broker tasks.
This role contains the account you designate in Master Data Services Configuration Manager when:
You should use the same account in both cases.
The mds_exec role has:
Contains all Master Data Services database and Service Broker objects other than the functions contained in the mdq schema.
Contains Master Data Services database functions related to filtering member results based on regular expressions or similarity, and for formatting notification e-mails.