Any suggestions? Export (0) Print
Expand All

Immediately Apply Member Permissions (Master Data Services)


Applies To: SQL Server 2016 Preview

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.

Community Additions

© 2016 Microsoft