DatabasePermissionSet.Add Method (DatabasePermissionSet, DatabasePermission)

Returns a database permission set after adding a new a database permission to the specified permission set.

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

Syntax

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

returnValue = DatabasePermissionSet.Add(permissionLeft, _
    permissionRight)

public static DatabasePermissionSet Add(
    DatabasePermissionSet permissionLeft,
    DatabasePermission permissionRight
)

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

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

public static function Add(
    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 permission to add.

Return Value

Type: Microsoft.SqlServer.Management.Smo.DatabasePermissionSet
A DatabasePermissionSet object that includes the new permission.

Examples

Granting, Revoking, and Denying Permissions

See Also

Reference

DatabasePermissionSet Class

Add Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Permissions (Database Engine)