Immediately Apply Member Permissions (Master Data Services)


Applies To: SQL Server 2016

In Master Data Services, instead of waiting for member security to be applied at regular intervals, you can apply member permissions immediately.

To perform this procedure:

To immediately apply hierarchy member permissions

  1. Open SQL Server Management Studio and connect to the Database Engine instance for your Master Data Services database.

  2. Create a new query.

  3. Type the following text, replacing database with the name of your database and Model_Name with the name of the model.

    USE [database];  
    DECLARE @Model_ID INT;  
    SELECT @Model_ID = ID FROM mdm.tblModel WHERE [Name] = N'Model_Name';  
    EXEC [mdm].[udpSecurityMemberProcessRebuildModel] @Model_ID=@Model_ID, @ProcessNow=1;  
  4. Run the query.

Assign Hierarchy Member Permissions (Master Data Services)
Hierarchy Member Permissions (Master Data Services)

Community Additions