Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
How To: Immediately Apply Member Permissions (Master Data Services)

How To: Immediately Apply Member Permissions (Master Data Services)

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];
    GO
    
    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;
    GO
    
  4. Run the query.

Community Additions

ADD
Show:
© 2015 Microsoft