| title | Assign Hierarchy Member Permissions | ||
|---|---|---|---|
| description | Assign Hierarchy Member Permissions (Master Data Services) | ||
| author | meetdeepak | ||
| ms.author | dkhare | ||
| ms.reviewer | mikeray | ||
| ms.date | 03/05/2026 | ||
| ms.service | sql | ||
| ms.subservice | master-data-services | ||
| ms.topic | how-to | ||
| ms.custom |
|
||
| helpviewer_keywords |
|
[!INCLUDE SQL Server - Windows only ASDBMI]
[!INCLUDE support-notice]
Assign permissions to hierarchy members to give users or groups access to view data in the Explorer functional area of [!INCLUDEssMDSmdm].
Hierarchy member permissions are optional. They provide added granularity to model object permissions, which are required.
To perform this procedure:
-
You must have permission to access the Users and Group Permissions functional area.
-
You must be a model administrator. For more information, see Administrators (Master Data Services).
-
In [!INCLUDEssMDSmdm], click User and Group Permissions.
-
On the Users or Groups page, select the row for the user or group that you want to edit.
-
Click Edit selected user.
-
Click the Hierarchy Members tab.
-
From the Model list, select a model.
-
From the Version list, select a version.
-
From the Hierarchy list, select a hierarchy.
-
Click Edit.
-
Expand the tree, and click the hierarchy node you want to assign permissions to.
-
From the menu, select a combination of Create, Read,Update and Delete permissions, or Deny permissions.
-
Click Save.
[!NOTE]
Hierarchy member permissions do not take effect immediately. See Immediately Apply Member Permissions (Master Data Services) for more information.
Delete Hierarchy Member Permissions (Master Data Services)
Assign Model Object Permissions (Master Data Services)
Hierarchy Member Permissions (Master Data Services)