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 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.
Master Data Services Super User