Repair-RDMUserSqlLogin

Synopsis

Fix the SQL login of an existing user

Syntax

__AllParameterSets

Repair-RDMUserSqlLogin [-InputObject] <PSUserInfo> [-PassThru] [-ForcePromptAnswer <DialogResult[]>]
 [<CommonParameters>]

Description

Fix the SQL login of an existing user, applicable to Microsoft Azure SQL or Microsoft SQL Server workspaces. Ensure the user's authentication type aligns with one of the following ServerUserType property values of the PSUserInfo object: SqlServer (2), AzureAD (8), or Okta (10).

Examples

PS C:\> Get-RDMUser -Name 'myUsername' | Repair-RDMUserSqlLogin

Fix the SQL login of the user named 'myUserName'

Parameters

-ForcePromptAnswer

Switch to use with caution. It will automatically answer prompt asking yes/no, yes/no/cancel, or ok/cancel questions. In case of multiple prompts, multiple values can be passed to this parameter. Here are the accepted values:

• Yes: Accept the prompt. Cover the OK and Automatic value.
• No: Refuse the yes/no/cancel prompt. "Cancel" is the fallback option if there is no "No" option.
• Cancel: Cancel the yes/no/cancel prompt. "No" is the fallback option if there is no "Cancel" option.

Type: System.Windows.Forms.DialogResult[]
DefaultValue: ''
SupportsWildcards: false
Aliases: []
ParameterSets:
- Name: (All)
  Position: Named
  IsRequired: false
  ValueFromPipeline: false
  ValueFromPipelineByPropertyName: false
  ValueFromRemainingArguments: false
DontShow: false
AcceptedValues: []
HelpMessage: ''

-InputObject

User needing SQL login fixing

Type: RemoteDesktopManager.PowerShellModule.PSOutputObject.PSUserInfo
DefaultValue: ''
SupportsWildcards: false
Aliases: []
ParameterSets:
- Name: (All)
  Position: 0
  IsRequired: true
  ValueFromPipeline: true
  ValueFromPipelineByPropertyName: false
  ValueFromRemainingArguments: false
DontShow: false
AcceptedValues: []
HelpMessage: ''

-PassThru

Return the PSUserInfo object after the SQL login fix

Type: System.Management.Automation.SwitchParameter
DefaultValue: ''
SupportsWildcards: false
Aliases: []
ParameterSets:
- Name: (All)
  Position: Named
  IsRequired: false
  ValueFromPipeline: false
  ValueFromPipelineByPropertyName: false
  ValueFromRemainingArguments: false
DontShow: false
AcceptedValues: []
HelpMessage: ''

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

Inputs

RemoteDesktopManager.PowerShellModule.PSOutputObject.PSUserInfo

User object obtained from Get-RDMUser

Notes

For more information, type "Get-Help Repair-RDMUserSqlLogin -detailed". For technical information, type "Get-Help Repair-RDMUserSqlLogin -full".