User.Grant Method (ObjectPermissionSet, String)

Grants access to the specified permission for the specified grantee on the database user.

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

Syntax

'Declaration
Public Sub Grant ( _
    permission As ObjectPermissionSet, _
    granteeName As String _
)
'Usage
Dim instance As User 
Dim permission As ObjectPermissionSet 
Dim granteeName As String

instance.Grant(permission, granteeName)

public void Grant(
    ObjectPermissionSet permission,
    string granteeName
)

public:
virtual void Grant(
    ObjectPermissionSet^ permission, 
    String^ granteeName
) sealed

abstract Grant : 
        permission:ObjectPermissionSet * 
        granteeName:string -> unit  
override Grant : 
        permission:ObjectPermissionSet * 
        granteeName:string -> unit

public final function Grant(
    permission : ObjectPermissionSet, 
    granteeName : String
)

Parameters

• permission
  Type: Microsoft.SqlServer.Management.Smo.ObjectPermissionSet
  An ObjectPermissionSet object that specifies the permission.

• granteeName
  Type: System.String
  A String value that specifies the grantee to be granted access to the permission.

Implements

IObjectPermission.Grant(ObjectPermissionSet, String)

Examples

Granting, Revoking, and Denying Permissions

See Also

Reference

User Class

Grant Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Managing Users, Roles, and Logins