Método UserDefinedFunction.Grant (ObjectPermissionSet, String, Boolean, String)
Grants the specified set of permissions to the grantee and the ability to grant the set of permissions to other users on the user-defined function under an assumed role.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)
Sintaxe
'Declaração
Public Sub Grant ( _
permission As ObjectPermissionSet, _
granteeName As String, _
grantGrant As Boolean, _
asRole As String _
)
'Uso
Dim instance As UserDefinedFunction
Dim permission As ObjectPermissionSet
Dim granteeName As String
Dim grantGrant As Boolean
Dim asRole As String
instance.Grant(permission, granteeName, _
grantGrant, asRole)
public void Grant(
ObjectPermissionSet permission,
string granteeName,
bool grantGrant,
string asRole
)
public:
virtual void Grant(
ObjectPermissionSet^ permission,
String^ granteeName,
bool grantGrant,
String^ asRole
) sealed
abstract Grant :
permission:ObjectPermissionSet *
granteeName:string *
grantGrant:bool *
asRole:string -> unit
override Grant :
permission:ObjectPermissionSet *
granteeName:string *
grantGrant:bool *
asRole:string -> unit
public final function Grant(
permission : ObjectPermissionSet,
granteeName : String,
grantGrant : boolean,
asRole : String
)
Parâmetros
- permission
Tipo: Microsoft.SqlServer.Management.Smo.ObjectPermissionSet
An ObjectPermissionSet object that specifies the set of permissions.
- granteeName
Tipo: System.String
A String value that specifies a grantee to be denied access to the set of permissions.
- grantGrant
Tipo: System.Boolean
A Boolean property that specifies whether the grantee is given the ability to grant the specified 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
Tipo: 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.
Implementa
IObjectPermission.Grant(ObjectPermissionSet, String, Boolean, String)
Exemplos
Concedendo, revogando e negando permissões
Consulte também
Referência
Namespace Microsoft.SqlServer.Management.Smo
Outros recursos
Funções definidas pelo usuário (Mecanismo de Banco de Dados)