Immediately apply member permissions (Master Data Services)
Applies to:
SQL Server - Windows only
Azure SQL Managed Instance
In Master Data Services, 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 Master Data Services database. For more information, see Database Object Security (Master Data Services).
To immediately apply hierarchy member permissions
Open SQL Server Management Studio and connect to the Database Engine instance for your Master Data Services database.
Create a new query.
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
Run the query.
See also
Assign Hierarchy Member Permissions (Master Data Services)
Hierarchy Member Permissions (Master Data Services)
Athugasemdir
https://aka.ms/ContentUserFeedback.
Væntanlegt: Á árinu 2024 munum við hætta með GitHub-mál sem ábendingaleið fyrir efni og skipta því út fyrir nýtt ábendingakerfi. Frekari upplýsingar er að finna hér:Senda inn og skoða endurgjöf fyrir