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

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
Immediately apply member permissions	Explaines how to apply member permissions immediately for Master Data Services	CordeliaGrey	jiwang6	03/01/2017	sql	master-data-services	conceptual	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]

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)