Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Administrators (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).

In Master Data Services, there are two types of administrators: model administrators, and the Master Data Services super user.

In Master Data Services, a model administrator is a user who has Admin permission assigned to the top-level model object on the Model Objects tab. When a user has Admin permission on a particular model, any other permissions on the model’s child objects (both model object and member permissions) are trumped by the model Admin permission and effectively ignored.

  • If the user has access to the Explorer functional area, the user can add, delete, and update all master data in this area.

  • If the user has access to other functional areas, the user can perform all administrative tasks available in the functional area.

Each model can have multiple administrators. Each user can be a model administrator for one, several, or all models in the Master Data Services deployment.

A user can be configured as a model administrator either in Master Data Services or programmatically. For more information, see Create a Model Administrator (Master Data Services).

In Master Data Services, a user who has Super User area function permission has full system access. The default super user is the user specified for the Administrator Account when you create the Master Data Services database.

The Master Data Services system administrator:

  • Automatically has access to all functional areas.

  • Can add, delete, and update all master data for all models in the Explorer functional area.

Multiple users and/or user groups may be assigned super user functional permission.

Administrator Type

Description

Master Data Services Super User

  • Permissions assigned in Master Data Services have no effect on the administrator’s access.

  • Can be a super user based on functional area permissions assigned explicitly or permissions inherited from a group.

  • Automatically has all permissions to all models.

  • Automatically has access to all functional areas.

Model administrator

  • Can be a model administrator based on admin permissions assigned explicitly or permissions inherited from a group.

  • Has access only to functional areas that access is granted to.

  • Automatically has all permissions to all objects and members in the specific model.

Community Additions

ADD
Show:
© 2015 Microsoft