UserDefinedDataType.Grant Method (ObjectPermissionSet, array<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 user-defined data type data type under an assumed role.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Sub Grant ( _
permission As ObjectPermissionSet, _
granteeNames As String(), _
grantGrant As Boolean, _
asRole As String _
)
'Usage
Dim instance As UserDefinedDataType
Dim permission As ObjectPermissionSet
Dim granteeNames As String()
Dim grantGrant As Boolean
Dim asRole As String
instance.Grant(permission, granteeNames, _
grantGrant, asRole)
public void Grant(
ObjectPermissionSet permission,
string[] granteeNames,
bool grantGrant,
string asRole
)
public:
virtual void Grant(
ObjectPermissionSet^ permission,
array<String^>^ granteeNames,
bool grantGrant,
String^ asRole
) sealed
abstract Grant :
permission:ObjectPermissionSet *
granteeNames:string[] *
grantGrant:bool *
asRole:string -> unit
override Grant :
permission:ObjectPermissionSet *
granteeNames:string[] *
grantGrant:bool *
asRole:string -> unit
public final function Grant(
permission : ObjectPermissionSet,
granteeNames : String[],
grantGrant : boolean,
asRole : String
)
Parameters
- permission
Type: Microsoft.SqlServer.Management.Smo.ObjectPermissionSet
An ObjectPermissionSet object that specifies the set of permissions.
- granteeNames
Type: array<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 user-defined data type.If True, the grantee is given the ability to grant the specified set of permissions to other users on the user-defined data type.If False, the grantee is not given the ability to grant the specified set of permissions to other users on the user-defined data type.
- 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 user-defined data type. Use this parameter for grantees who are members of more than one role.
Implements
IObjectPermission.Grant(ObjectPermissionSet, array<String[], Boolean, String)
Examples
Granting, Revoking, and Denying Permissions
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace