UserDefinedFunction.Grant Method (ObjectPermissionSet, array<String[], 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 specified columns on the user-defined function 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(), _
columnNames As String(), _
grantGrant As Boolean, _
asRole As String _
)
'Usage
Dim instance As UserDefinedFunction
Dim permission As ObjectPermissionSet
Dim granteeNames As String()
Dim columnNames As String()
Dim grantGrant As Boolean
Dim asRole As String
instance.Grant(permission, granteeNames, _
columnNames, grantGrant, asRole)
public void Grant(
ObjectPermissionSet permission,
string[] granteeNames,
string[] columnNames,
bool grantGrant,
string asRole
)
public:
virtual void Grant(
ObjectPermissionSet^ permission,
array<String^>^ granteeNames,
array<String^>^ columnNames,
bool grantGrant,
String^ asRole
) sealed
abstract Grant :
permission:ObjectPermissionSet *
granteeNames:string[] *
columnNames:string[] *
grantGrant:bool *
asRole:string -> unit
override Grant :
permission:ObjectPermissionSet *
granteeNames:string[] *
columnNames:string[] *
grantGrant:bool *
asRole:string -> unit
public final function Grant(
permission : ObjectPermissionSet,
granteeNames : String[],
columnNames : 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.
- columnNames
Type: array<System.String[]
A String array value that specifies the list of columns to which the set of permissions is granted.
- 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 function.If True, the grantee is given the ability to grant the specified set of permissions to other users on the user-defined function.If False, the grantee is not given the ability to grant the specified set of permissions to other users on the user-defined function.
- 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 function. Use this parameter for grantees who are members of more than one role.
Implements
IColumnPermission.Grant(ObjectPermissionSet, array<String[], array<String[], Boolean, String)
Examples
Granting, Revoking, and Denying Permissions
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace