Grant 方法 (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.
命名空間: Microsoft.SqlServer.Management.Smo
組件: Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)
語法
'宣告
Public Sub Grant ( _
permission As ObjectPermissionSet, _
granteeNames As String(), _
columnNames As String(), _
grantGrant As Boolean, _
asRole As String _
)
'用途
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
)
參數
- permission
型別:Microsoft.SqlServer.Management.Smo. . :: . .ObjectPermissionSet
An ObjectPermissionSet object that specifies the set of permissions.
- granteeNames
型別:array<System. . :: . .String> [] () [] []
A String array that specifies a list of grantees to be granted the set of permissions.
- columnNames
型別:array<System. . :: . .String> [] () [] []
A String array value that specifies the list of columns to which the set of permissions is granted.
- grantGrant
型別: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
型別: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.