Database Logins, Users, and Roles (Master Data Services)

 

Applies To: SQL Server 2016

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.

LoginDescription
mds_dlp_loginAllows creation of UNSAFE assemblies. For more information, see Creating an Assembly.

-Disabled login with randomly-generated password.

-Maps to dbo for the Master Data Services database.

-For msdb, mds_clr_user maps to this login.
mds_email_loginEnabled login used for notifications.

For msdb and the Master Data Services database, mds_email_user maps to this login.
UserDescription
mds_clr_userNot used. Maps to mds_dlp_login.
mds_email_userUsed for notifications.

-Maps to mds_email_login.

-Is a member of the role: DatabaseMailUserRole.
UserDescription
mds_email_userUsed for notifications.

-Has SELECT permission for the mdm schema.

-Has EXECUTE permission for the mdm.MemberGetCriteria user defined table type.

-Has EXECUTE permission for the mdm.udpNotificationQueueActivate stored procedure.
mds_schema_userOwns the mdm and mdq schemas. The default schema is mdm.

Does not have a login mapped to it.
mds_ssb_userUsed to execute Service Broker tasks.

-Has DELETE, INSERT, REFERENCES, SELECT, and UPDATE permission all schemas.

-Does not have a login mapped to it.
RoleDescriptionPermissions
mds_execThis role contains the account you designate in Master Data Services Configuration Manager when you create a Master Data Manager web application and designate an account for the application pool.EXECUTE permission on all schemas.

 

ALTER, INSERT, and SELECT permission on these tables:

mdm.tblStgMember

mdm.tblStgMemberAttribute

mdm.tbleStgRelationship

 

SELECT permission on these tables:

mdm.tblUser

mdm.tblUserGroup

mdm.tblUserPreference

 

SELECT permission on these views:

mdm.viw_SYSTEM_SECURITY_NAVIGATION

mdm.viw_SYSTEM_SECURITY_ROLE_ACCCESSCONTROL

mdm.viw_SYSTEM_SECURITY_ROLE_ACCCESSCONTROL_MEMBER

mdm.viw_SYSTEM_SECURITY_USER_MODEL
RoleDescription
mdmContains all Master Data Services database and Service Broker objects other than the functions contained in the mdq schema.
mdqContains Master Data Services database functions related to filtering member results based on regular expressions or similarity, and for formatting notification emails.
stgContains Master Data Services database tables, stored procedures, and views related to the staging process. Do not delete any of these objects. For more information about the staging process, see Overview: Importing Data from Tables (Master Data Services).

Database Object Security (Master Data Services)

Community Additions

ADD
Show: