Overlapping User and Group Permissions (Master Data Services)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
A user's permissions are based on:
Permissions from group memberships.
Permissions assigned explicitly to the user.
If a user is a member of multiple groups, and those groups have access to Master Data Services, the following rules apply:
Deny overrides all other permissions. If the object permission is Deny in one group, the effective permission is deny.
Access permission is a union all effective permissions on a group. If the object permission is Create from one group and Update from other group, the effective permission is Create and Update.
These rules apply to both the Models and Hierarchy Members tabs. Permissions are resolved for each tab and then combined. For more information, see How Permissions Are Determined (Master Data Services).
You can view the resolution of user and group overlapping permissions in the user interface. Both the Models and Hierarchy Members tab have a drop-down list from which you can choose Effective to view effective permissions.
The user belongs to Group 1 and Group 2.
The user has Update permission to a group of members in a hierarchy node.
Group 1 has Read permission to a group of members in a hierarchy node.
Group 2 has Read permission to a group of members in a hierarchy node.
Result: The user's effective permission is Update to the members.