Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide

Time for action – permission walkthrough

In this example, we will go through the permission and security options and explore the options that are provided to the security administrator to apply security to the desired model.

1. Open the WebUI of MDS. Go to User and Group Permissions.
2. Click on the Add button and then enter the name of a user in the add user window (the user needs to be a Windows / Active Directory user; you might need to add a Windows user to run this example). You can also add an Active Directory group from the Manage Groups menu.
3. Then, go to the Edit window. In the Functions tab, you can set which functions in the main WebUI menu are accessible for users (functions such as explorer and version management).
4. To change permissions, you ...