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.
Collection permissions apply to all collections for an entity. You cannot give permission to a specific collection; permissions apply to all collections.
Note
These permissions apply to the Explorer functional area of the user interface only.
| Permission | Description |
|---|---|
| Read | User can read collection members and the member attributes. |
| Create | User can create collection members and assign attribute values. |
| Update | User can update collection members, attributes and relationships. |
| Delete | User can delete collection members. |
| Deny | Deny all access to the collection members. |
The Read, Create, Update, and Delete permissions can be combined. When Create, Update and Delete are assigned, the read permission is assigned automatically.
See Also
Assign Model Object Permissions (Master Data Services)
Collections (Master Data Services)
Model Object Permissions (Master Data Services)