Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server - Windows only
Azure SQL Managed Instance
In Master Data Services, create a model administrator when you want a group or user to have all permissions to all objects in one or more models.
Tip
To simplify administration, create a Windows or local group and configure it as a model administrator. You can then add and remove users from the group without accessing Master Data Manager.
To perform this procedure:
You must have permission to access the User and Group Permissions functional area.
You must be a model administrator. For more information, see Administrators (Master Data Services).
In Master Data Manager, click User and Group Permissions.
On the Users or Groups page, select the row for the user or group that you want to edit.
Click Edit selected user.
Click the Models tab.
Optionally, select a model from the Model list.
Click Edit.
Click the model you want to grant permission to.
From the menu, select Admin.
Complete steps 7 and 8 for each model you want the group or user to be an administrator for.
Click Save.
Administrators (Master Data Services)
Assign Model Object Permissions (Master Data Services)
Assign Hierarchy Member Permissions (Master Data Services)
Model Object Permissions (Master Data Services)
Hierarchy Member Permissions (Master Data Services)
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Design a Performant Data Model in Azure SQL Database with Azure Data Studio - Training
Learn how to create a data model, tables, indexes, constraints, and use data types with Azure data studio.
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.