UserDefinedDataType.Grant Method (ObjectPermissionSet, 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)

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

Parameters

permission
Type: Microsoft.SqlServer.Management.Smo.ObjectPermissionSet

An ObjectPermissionSet object that specifies the set of permissions.

granteeNames
Type: 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.

Return to top
Show: