Server.EnumServerPermissions Method (ServerPermissionSet)

 

Enumerates a list of server permissions for a specified permission on the instance of SQL Server.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Public Function EnumServerPermissions (
	permissions As ServerPermissionSet
) As ServerPermissionInfo()

Parameters

permissions
Type: Microsoft.SqlServer.Management.Smo.ServerPermissionSet

A ServerPermissionSet value that specifies the permission.

Return Value

Type: Microsoft.SqlServer.Management.Smo.ServerPermissionInfo()

An array of ServerPermissionInfo objects that contains server permission information for the specified permission on the instance of SQL Server.

Use this method to return an array of ServerPermissionInfo objects that contain information about the permissions currently set on the instance of SQL Server for the given set of permissions.

Visual Basic

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$arg = [Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint

$sps = new-object Microsoft.SqlServer.Management.Smo.ServerPermissionSet([Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint)
$sps.Add([Microsoft.SqlServer.Management.Smo.ServerPermission]::AlterAnyEndpoint)
$spis = $srv.EnumServerPermissions("vGrantee", $sps)
Write-Host "=================Before revoke==========================="
Foreach ($spi In $spis)
{
   Write-Host $spi.Grantee "has" $spi.PermissionType " permission."
}
Write-Host " "
$sps.Remove([Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint)
Return to top
Show: