Administrators

Administrators (Master Data Services)

 

Applies To: SQL Server 2016 Preview

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 Manager or programmatically. For more information, see Create a Model Administrator (Master Data Services).

In Master Data Services, an entity administrator is a user who has administrator permissions assigned to the entity object on the Model Objects tab. When a user has administrator permissions for an entity, any other permissions on the entity’s child objects (both model object and member permissions) are superseded by the administrator permissions and are 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 entity changes require administrator approval, an entity administrator can review and then approve or reject change sets.

Each entity can have multiple administrators. Each user can be a entity administrator for one, several, or all entities.

A user can be configured as an entity administrator either in Master Data Services or programmatically. For more information, see Create an Entity 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 Manager 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.

Entity administrator

  • Can be an entity administrator based on administrator 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 entity.

  • Can approve the pending change sets if the entity changes require approval.

Community Additions

ADD
Show:
© 2016 Microsoft