DatabasePermission.Add Method

Returns a set of database permissions after adding a new database permission to an existing set of database permissions.

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

Syntax

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

returnValue = DatabasePermission.Add(permissionLeft, _
    permissionRight)

public static DatabasePermissionSet Add(
    DatabasePermission permissionLeft,
    DatabasePermission permissionRight
)

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

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

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

Parameters

• permissionLeft
  Type: Microsoft.SqlServer.Management.Smo.DatabasePermission
  A DatabasePermission object that specifies the server permission.

• permissionRight
  Type: Microsoft.SqlServer.Management.Smo.DatabasePermission
  A DatabasePermission object that specifies the server permission.

Return Value

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

Examples

Granting, Revoking, and Denying Permissions

See Also

Reference

DatabasePermission Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Permissions (Database Engine)

sys.server_permissions (Transact-SQL)