immediately-apply-member-permissions-master-data-services.md

title	Immediately Apply Member Permissions
description	Explains how to apply member permissions immediately for Master Data Services
author	meetdeepak
ms.author	dkhare
ms.reviewer	mikeray
ms.date	03/05/2026
ms.service	sql
ms.subservice	master-data-services
ms.topic	how-to
ms.custom	build-2025
helpviewer_keywords	members [Master Data Services], applying permissions immediately permissions [Master Data Services], applying member permissions immediately

Immediately apply member permissions (Master Data Services)

[!INCLUDE SQL Server - Windows only ASDBMI]

[!INCLUDE support-notice]

In [!INCLUDEssMDSshort], instead of waiting for member security to be applied at regular intervals, you can apply member permissions immediately.

Prerequisites

To perform this procedure:

• You must have permission to execute the mdm.udpSecurityMemberProcessRebuildModel stored procedure in the [!INCLUDEssMDSshort] database. For more information, see Database Object Security (Master Data Services).

To immediately apply hierarchy member permissions

1. Open [!INCLUDEssManStudioFull] and connect to the [!INCLUDEssDE] instance for your [!INCLUDEssMDSshort] 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.

See also

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