Muistiinpano
Tämän sivun käyttö edellyttää valtuutusta. Voit yrittää kirjautua sisään tai vaihtaa hakemistoa.
Tämän sivun käyttö edellyttää valtuutusta. Voit yrittää vaihtaa hakemistoa.
Applies to: 
SQL Server on Windows
Azure SQL Managed Instance
Important
Master Data Services (MDS) is removed in SQL Server 2025 (17.x). 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)