立即应用成员权限 (Master Data Services)Immediately Apply Member Permissions (Master Data Services)

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) - 仅限 Windows 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) - Windows only 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance

Master Data ServicesMaster Data Services中,您可以立即应用成员权限,而不必等待定期应用的成员安全性。In Master Data ServicesMaster 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:

立即应用层次结构成员权限To immediately apply hierarchy member permissions

  1. 打开 SQL Server Management StudioSQL Server Management Studio 并连接到 数据库引擎Database Engine 数据库的 Master Data ServicesMaster Data Services 实例。Open SQL Server Management StudioSQL Server Management Studio and connect to the 数据库引擎Database Engine instance for your Master Data ServicesMaster Data Services database.

  2. 创建新查询。Create a new query.

  3. 键入以下文本,用数据库名称替换 database,用模型名称替换 Model_Name。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

将层次结构成员权限分配 (Master Data Services) Assign Hierarchy Member Permissions (Master Data Services)
层次结构成员权限 (Master Data Services)Hierarchy Member Permissions (Master Data Services)