Export (0) Print
Expand All

UserDefinedFunction.Grant Method (ObjectPermissionSet, String[], 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)

public void Grant(
	ObjectPermissionSet permission,
	string[] granteeNames,
	string[] columnNames,
	bool grantGrant,
	string asRole
)

Parameters

permission
Type: Microsoft.SqlServer.Management.Smo.ObjectPermissionSet
An ObjectPermissionSet object that specifies the set of permissions.
granteeNames
Type: String[]
A String array that specifies a list of grantees to be granted the set of permissions.
columnNames
Type: String[]
A String array value that specifies the list of columns to which the set of permissions is granted.
grantGrant
Type: 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: 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, String[], String[], Boolean, String)
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft