Consolidated 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).

Consolidated permissions apply to the attribute values for all consolidated members of an entity.

Consolidated permissions apply only to entities that are enabled for explicit hierarchies and collections.

Notes:

  • Leaf permissions apply to the Explorer functional area of the user interface only.

  • Permissions assigned to Name and Code attributes are not enforced.

Permission

Description

Read

User can read consolidated members and the member attributes.

Create

User can create consolidated members and assign attribute values.

Update

User can update consolidated members, attributes and relationships.

Delete

User can delete consolidated members.

Deny

Deny all access to the consolidated members.

The Read, Create, Update, and Delete permissions can be combined. When Create, Update and Delete are assigned, the read permission is assigned automatically.

Attribute Permissions

Attribute permissions apply to the attribute’s values for the specific entity. Users with only attribute permissions cannot add or remove members.

Permission

Description

Read

User can read attributes.

Create

User can assign values when they create the attribute.

Update

User can update attributes.

Delete

No effect.

Deny

The attribute is not displayed.

Note

You cannot explicitly deny access to Name and Code attributes.

See Also

Tasks

Assign Model Object Permissions (Master Data Services)

Concepts

Leaf Permissions (Master Data Services)

Model Object Permissions (Master Data Services)

Members (Master Data Services)

Attributes (Master Data Services)