TechNet
Export (0) Print
Expand All

Server.EnumServerPermissions Method (String, ServerPermissionSet)

 

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

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

public ServerPermissionInfo[] EnumServerPermissions(
	string granteeName,
	ServerPermissionSet permissions
)

Parameters

granteeName
Type: System.String

A String value that specifies the grantee.

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

A ServerPermissionSet object 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 grantee and 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 specified grantee and 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:
© 2016 Microsoft