Remove-MgmtSvcDatabaseUser

Removes a principal from the database.

Syntax

Parameter Set: Default
Remove-MgmtSvcDatabaseUser -Schema <String> -User <String> [-ConnectionString <String> ] [-Database <String> ] [-Password <String> ] [-Server <String> ] [-UserName <String> ] [-Confirm] [-WhatIf] [ <CommonParameters>]

Detailed Description

The Remove-MgmtSvcDatabaseUser cmdlet removes a principal account for a specified schema from the database. Specify the user name and schema.

You can run this cmdlet from any computer in the deployment. However, this cmdlet assumes that the database is on the local computer. If the database is on another computer, you must use the Server, UserName, Password, and Database parameters, or a SQL connection string. If you specify a connection string by using the ConnectionString parameter, that value takes precedence over the Server, UserName, Password, and Database parameters.

Use this cmdlet when uninstalling Windows Azure Pack for Windows Server. When you uninstall the product, you must uninstall the databases and remove the database users.

Parameters

-ConnectionString<String>

Specifies an SQL connection string.

Aliases	none
Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

-Database<String>

Specifies a database name.

Aliases	none
Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

-Password<String>

Specifies a password.

Aliases	none
Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

-Schema<String>

Specifies a schema.

Aliases	none
Required?	true
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

-Server<String>

Specifies the name of the computer on which the SQL database resides.

Aliases	none
Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

-User<String>

Specifies the user name of a principal. The cmdlet removes this account from the database for the specified schema.

Aliases	none
Required?	true
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

-UserName<String>

Specifies the name of a user account.

Aliases	none
Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

-Confirm

Prompts you for confirmation before executing the command.

Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

-WhatIf

Describes what would happen if you executed the command without actually executing the command.

Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

<CommonParameters>

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see about_CommonParameters.

Examples

Example 1: Remove a user account

This command removes the user named MgmtSvc-Usage from the Usage schema in the database named Contoso.MgmtSvc.Usage. The command specifies the computer that runs SQL server as ContosoSQLServer. The command also specifies a user named SysAdmin, which has permissions to make this change, along with the password for that account.

PS C:\> Remove-MgmtSvcDatabaseUser -Schema "Usage" -User "MgmtSvc-Usage" -Database "Microsoft.MgmtSvc.Usage" -Password "PassWord!" -Server "ContosoSQLServer" -UserName "SysAdmin"

Remove-MgmtSvcDatabaseUser