Checks if the current user in the database has the sysadmin role.
Test-MssqlAdministrator [[-conn] <Object>] [[-udl] <String>] [[-connStr] <String>] [<CommonParameters>]
The Test-MssqlAdministrator function checks whether the current user in the specified SQL Server database has the sysadmin role. It can be used to determine whether or not the user has administrative privileges in the database.
Example 1: Tests if the user specified in udl is in the sysadmin role #
PS C:\> Test-MssqlAdministrator -udl '.\source\tests\Eulanda_1 Pester.udl'
This example checks if the current user has the sysadmin role in the database configured in the UDL file ‘.\source\tests\Eulanda_1 Pester.udl’. If the user is sysadmin, the result will return “True”, otherwise “False”.
The connection can be established via an existing ADO object of the type ‘ADODB.Connection’. If the connection is already open, it remains open even after the function has been executed. If it was closed, it will be closed again after the function has been executed.
Type: Object Parameter Sets: (All) Aliases: Required: False Position: 0 Default value: None Accept pipeline input: False Accept wildcard characters: False
ConnectionString can be specified here, with which a database can be opened.
Type: String Parameter Sets: (All) Aliases: Required: False Position: 2 Default value: None Accept pipeline input: False Accept wildcard characters: False
Alternatively to a connection, a string to a UDL file can be specified. In this case an ADO object is created and closed again at the end of the function.
Type: String Parameter Sets: (All) Aliases: Required: False Position: 1 Default value: None Accept pipeline input: False Accept wildcard characters: False
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.