Server.Grant Method (ServerPermissionSet, String[], Boolean, String)
Grants the specified set of permissions to the grantees and the ability to grant the set of permissions to other users on the instance of SQL Server under an assumed role.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
public void Grant( ServerPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole )
Parameters
- permission
-
Type:
Microsoft.SqlServer.Management.Smo.ServerPermissionSet
A ServerPermissionSet object that specifies the permission.
- granteeNames
-
Type:
System.String[]
A String array that specifies a list of grantees to be granted the set of permissions.
- grantGrant
-
Type:
System.Boolean
A Boolean property that specifies whether the grantee is given the ability to grant the set of permissions to other users on the instance of SQL Server.
If True, the grantee is given the ability to grant the specified set of permissions to other users on the instance of SQL Server.
If False, the grantee is not given the ability to grant the specified set of permissions to other users on the instance of SQL Server.
- asRole
-
Type:
System.String
A String value that specifies the role that the user assumes when granting the specified set of permissions to other users on the instance of SQL Server. Use this parameter for grantees who are members of more than one role.
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)