Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server - Windows only
Azure SQL Managed Instance
Important
Master Data Services (MDS) is removed in SQL Server 2025 (17.x) Preview. We continue to support MDS in SQL Server 2022 (16.x) and earlier versions.
Entity permissions apply to:
All of the entity's attributes, including Name and Code, for both leaf and consolidated members.
All of the entity's collections.
Explicit hierarchy memberships and relationships.
When you have permission to an entity, you can add and remove members from the entity, its explicit hierarchies, and its collections.
Note
These permissions apply to the Explorer functional area of the user interface only.
| Permission | Description |
|---|---|
| Read | User can read members, attributes, hierarchy memberships, or collection memberships. |
| Create | User can create members, and assign attribute values during create. |
| Update | User can update members, attributes, hierarchy memberships, or collection memberships. |
| Delete | User can delete members. |
| Deny | Deny all access to the entity. |
The Read, Create, Update, and Delete permissions can be combined with each other. When Create, Update and Delete permissions are assigned, the read permission will be assigned automatically.
See Also
Assign Model Object Permissions (Master Data Services)
Model Object Permissions (Master Data Services)
Entities (Master Data Services)