Remove-RoleMember

参考

模块:: SQLServer

从特定数据库的特定角色中删除成员。

语法

Remove-RoleMember
      [-MemberName] <String>
      [-Database] <String>
      [-RoleName] <String>
      [-Server <String>]
      [-Credential <PSCredential>]
      [-ServicePrincipal]
      [-ApplicationId <String>]
      [-TenantId <String>]
      [-CertificateThumbprint <String>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]

Remove-RoleMember
      [-MemberName] <String>
      -DatabaseRole <Role>
      [-Server <String>]
      [-Credential <PSCredential>]
      [-ServicePrincipal]
      [-ApplicationId <String>]
      [-TenantId <String>]
      [-CertificateThumbprint <String>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]

Remove-RoleMember
      [-MemberName] <String>
      -ModelRole <ModelRole>
      [-Server <String>]
      [-Credential <PSCredential>]
      [-ServicePrincipal]
      [-ApplicationId <String>]
      [-TenantId <String>]
      [-CertificateThumbprint <String>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]

Remove-RoleMember
      [-Server <String>]
      [-Credential <PSCredential>]
      [-ServicePrincipal]
      [-ApplicationId <String>]
      [-TenantId <String>]
      [-CertificateThumbprint <String>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]

说明

Remove-RoleMember cmdlet 根据输入值，从特定数据库的特定角色中删除现有成员。

Module requirements: version 21+ on PowerShell 5.1; version 21 (recent preview) or version 22+ on PowerShell 7.x.

示例

示例 1：使用管道删除角色成员

PS SQLServer:\SQLAS\machine\instance\Databases\DB1\Roles> $roles = Get-Children
PS SQLServer:\SQLAS\machine\instance\Databases\DB1\Roles> $roles[0] | Remove-RoleMember -MemberName "foo\user1"

示例 2：使用名称删除角色成员

PS SQLServer:\SQLAS\machine\instance\Databases\DB1\Roles> Remove-RoleMember -MemberName "foo\user1" -Database "DB1" -RoleName "myRole"

参数

-ApplicationId

服务主体的应用程序 ID。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-CertificateThumbprint

服务主体的证书指纹。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Confirm

提示你在运行 cmdlet 之前进行确认。

Type:	SwitchParameter
Aliases:	cf
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Credential

如果指定此参数，将使用传递的用户名和密码连接到指定的 Analysis Server 实例。如果未指定凭据，将使用正在运行该工具的用户的默认 Windows 帐户。

Type:	PSCredential
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Database

角色所属的数据库名称。

Type:	String
Position:	1
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-DatabaseRole

应从中删除此成员的 Microsoft.AnalysisServices.Role 对象。仅) 多维元数据 (

Type:	Role
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-MemberName

应删除的成员的名称。

Type:	String
Position:	0
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-ModelRole

管道角色对象。

Type:	ModelRole
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-RoleName

应从中删除此成员的角色名称。

Type:	String
Position:	2
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-Server

（可选）指定要连接到的服务器实例（如果当前不在 SQLAS 提供程序目录中）。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-ServicePrincipal

指定此连接使用服务主体。

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-TenantId

服务主体的租户 ID。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-WhatIf

显示在此 cmdlet 运行的情况下将会发生什么。此 cmdlet 未运行。

Type:	SwitchParameter
Aliases:	wi
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

输入

Microsoft.AnalysisServices.Role

Microsoft.AnalysisServices.Tabular.ModelRole

备注

在所有 Analysis Services 实例上都受支持