Add-RoleMember
Adds a member to a specific Role of a specific database.
Syntax
Add-RoleMember
-MemberName <String>
[-Database] <String>
[-RoleName] <String>
[-Server <String>]
[-Credential <PSCredential>]
[-ServicePrincipal]
[-ApplicationId <String>]
[-TenantId <String>]
[-CertificateThumbprint <String>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Add-RoleMember
-MemberName <String>
-DatabaseRole <Role>
[-Server <String>]
[-Credential <PSCredential>]
[-ServicePrincipal]
[-ApplicationId <String>]
[-TenantId <String>]
[-CertificateThumbprint <String>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Add-RoleMember
-MemberName <String>
-ModelRole <ModelRole>
[-Server <String>]
[-Credential <PSCredential>]
[-ServicePrincipal]
[-ApplicationId <String>]
[-TenantId <String>]
[-CertificateThumbprint <String>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Add-RoleMember
[-Server <String>]
[-Credential <PSCredential>]
[-ServicePrincipal]
[-ApplicationId <String>]
[-TenantId <String>]
[-CertificateThumbprint <String>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Description
The Add-RoleMember cmdlet adds a valid member to a specific Role of a specific database depending upon the input values.
Note: This cmdlet is only available for PowerShell 5. Currently, it is available for PowerShell 7 in recent **preview** versions of the module.
Examples
Example 1: Add member to role using pipeline
PS SQLServer:\SQLAS\machine\instance\Databases\DB1\Roles\> $roles = Get-Children
PS SQLServer:\SQLAS\machine\instance\Databases\DB1\Roles\> $roles[0] | Add-RoleMember -MemberName "memberName"
This command adds a member to the first role of a given database.
Example 2: Add member to role using pipeline in Tabular 1200
PS SQLServer:\SQLAS\machine\instance\Databases\DB1\Roles\> $roles = Get-Children
PS SQLServer:\SQLAS\machine\instance\Databases\DB1\Roles\> Add-RoleMember -MemberName "memberName" -ModelRole $roles[0]
Add a member to the first role of a given database using named parameters for a tabular database with compatibility level 1200 or higher.
Example 3: Add member to role using name
PS C:\> Add-RoleMember -MemberName "foo\user1" -Database "DB1" -RoleName "myRole"
Add a member to the database role using the role's name
Parameters
The application Id for the service principal.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
The certificate thumbprint for the service principal.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Prompts you for confirmation before running the cmdlet.
| Type: | SwitchParameter |
| Aliases: | cf |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
If this parameter is specified, the user name and password passed will be used to connect to specified Analysis Server instance. If no credentials are specified default windows account of the user who is running the tool will be used.
| Type: | PSCredential |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Database name to which the Role belongs to.
| Type: | String |
| Position: | 1 |
| Default value: | None |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
The Microsoft.AnalysisServices.Role to add a member to. This not applicable to tabular databases with compatibility level 1200 or higher.
| Type: | Role |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
Name of the member who should be added to the role.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
{{Fill ModelRole Description}}
| Type: | ModelRole |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
Name of the Role to which the member should be added.
| Type: | String |
| Position: | 2 |
| Default value: | None |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Optionally specifies the server instance to connect to if not currently in the SQLAS Provider directory.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Specifies that this connection is using service principal.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
The tenant Id for the service principal.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Shows what would happen if the cmdlet runs. The cmdlet is not run.
| Type: | SwitchParameter |
| Aliases: | wi |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Inputs
Microsoft.AnalysisServices.Role
Microsoft.AnalysisServices.Tabular.ModelRole
Outputs
System.Object
None
Notes
Supported on all Analysis Services instances Currently unsupported by the PowerBI Premium Product. It will be supported in the future.