DatabasePermissionSet.Subtract Method

Returns a database permission set after removing a database permission from the specified permission set.

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

Syntax

'Declaration
Public Shared Function Subtract ( _
    permissionLeft As DatabasePermissionSet, _
    permissionRight As DatabasePermission _
) As DatabasePermissionSet
'Usage
Dim permissionLeft As DatabasePermissionSet 
Dim permissionRight As DatabasePermission 
Dim returnValue As DatabasePermissionSet 

returnValue = DatabasePermissionSet.Subtract(permissionLeft, _
    permissionRight)

public static DatabasePermissionSet Subtract(
    DatabasePermissionSet permissionLeft,
    DatabasePermission permissionRight
)

public:
static DatabasePermissionSet^ Subtract(
    DatabasePermissionSet^ permissionLeft, 
    DatabasePermission^ permissionRight
)

static member Subtract : 
        permissionLeft:DatabasePermissionSet * 
        permissionRight:DatabasePermission -> DatabasePermissionSet

public static function Subtract(
    permissionLeft : DatabasePermissionSet, 
    permissionRight : DatabasePermission
) : DatabasePermissionSet

Parameters

• permissionLeft
  Type: Microsoft.SqlServer.Management.Smo.DatabasePermissionSet
  A DatabasePermissionSet object that specifies the database permission set.

• permissionRight
  Type: Microsoft.SqlServer.Management.Smo.DatabasePermission
  A DatabasePermission object that specifies the database permission to be removed.

Return Value

Type: Microsoft.SqlServer.Management.Smo.DatabasePermissionSet
A DatabasePermissionSet object value that specifies a set of database permissions.

Examples

Granting, Revoking, and Denying Permissions

See Also

Reference

DatabasePermissionSet Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Permissions (Database Engine)