Compartilhar via

Classe ObjectPermissionSet

  • Artigo

The ObjectPermissionSet object represents a set of object permissions in Microsoft SQL Server.

Hierarquia de herança

System.Object
  Microsoft.SqlServer.Management.Smo.PermissionSetBase
    Microsoft.SqlServer.Management.Smo.ObjectPermissionSet

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)

Sintaxe

'Declaração
Public NotInheritable Class ObjectPermissionSet _
    Inherits PermissionSetBase
'Uso
Dim instance As ObjectPermissionSet

public sealed class ObjectPermissionSet : PermissionSetBase

public ref class ObjectPermissionSet sealed : public PermissionSetBase

[<SealedAttribute>]
type ObjectPermissionSet =  
    class 
        inherit PermissionSetBase 
    end

public final class ObjectPermissionSet extends PermissionSetBase

O tipo ObjectPermissionSet expõe os membros a seguir.

Construtores

  Nome Descrição
Método público ObjectPermissionSet() Initializes a new instance of the ObjectPermissionSet class.
Método público ObjectPermissionSet(ObjectPermission) Initializes a new instance of the ObjectPermissionSet class based on the specified object permission.
Método público ObjectPermissionSet(array<ObjectPermission[]) Initializes a new instance of the ObjectPermissionSet class based on the specified set of object permissions.
Método público ObjectPermissionSet(ObjectPermissionSet) Initializes a new instance of the ObjectPermissionSet class based on the specified set of object permissions.

Início

Propriedades

  Nome Descrição
Propriedade pública Alter Gets or sets the Boolean property value that specifies whether to include the ALTER permission in the permission set. The permission lets the grantee change properties, except ownership, of the object.
Propriedade pública Connect Gets or sets the Boolean property value that specifies whether to include the CONNECT permission in the permission set. The permission lets the grantee create a connection between the object and an instance of SQL Server.
Propriedade pública Control Gets or sets the Boolean property value that specifies whether to include the CONTROL permission in the permission set. The permission gives the grantee full control over the object, including all defined permissions for the object, the ability to create permissions on the object, and full control over child objects.
Propriedade pública CreateSequence Gets or sets the Boolean property value that specifies whether to include the CREATE SEQUENCE permission in the permission set. This permission gives the grantee the ability to create a sequence within the database.
Propriedade pública Delete Gets or sets the Boolean property value that specifies whether to include the DELETE permission in the permission set. The permission lets the grantee delete the object.
Propriedade pública Execute Gets or sets the Boolean property value that specifies whether to include the EXECUTE permission in the permission set. The permission lets the grantee execute the object.
Propriedade pública Impersonate Gets or sets the Boolean property value that specifies whether to include the IMPERSONATE permission in the permission set. The permission lets the grantee impersonate the user or the login.
Propriedade pública Insert Gets or sets the Boolean property value that specifies whether to include the INSERT permission in the permission set. The permission lets the grantee insert data into the object.
Propriedade pública Receive Gets or sets the Boolean property value that specifies whether to include the RECEIVE permission in the permission set. The permission lets the grantee receive messages from a Service Broker queue.
Propriedade pública References Gets or sets the Boolean property value that specifies whether to include the REFERENCES permission in the permission set. This permission lets the grantee reference data in the object.
Propriedade pública Select Gets or sets the Boolean property value that specifies whether to include the SELECT permission in the permission set. This permission lets the grantee retrieve data from the object.
Propriedade pública Send Gets or sets the Boolean property value that specifies whether to include the SEND permission in the permission set. This permission lets the grantee send messages to a Service Broker service.
Propriedade pública TakeOwnership Gets or sets the Boolean property value that specifies whether to include the TAKE OWNERSHIP permission in the permission set. This permission lets the grantee take ownership of the object.
Propriedade pública Update Gets or sets the Boolean property value that specifies whether to include the UPDATE permission in the permission set. This permission lets the grantee modify data in the object.
Propriedade pública ViewChangeTracking Gets or sets the Boolean property value that specifies whether to include the VIEW CHANGE TRACKING permission in the permission set. This permission lets the grantee view the tracking information for a database object.
Propriedade pública ViewDefinition Gets or sets the Boolean property value that specifies whether to include the VIEW DEFINITION permission in the permission set. This permission lets the grantee view the metadata that defines the object.

Início

Métodos

  Nome Descrição
Método público Add(ObjectPermission) Returns an object permission set after adding a new object permission to the referenced permission set.
Método públicoMembro estático Add(ObjectPermissionSet, ObjectPermission) Returns an object permission set after adding a new object permission to the referenced permission set.
Método público Equals Determines whether the current ObjectPermissionSet object is equal to a specified object. (Substitui PermissionSetBase.Equals(Object).)
Método público GetHashCode This method supports the SQL Server infrastructure and is not intended to be used directly from your code. (Substitui PermissionSetBase.GetHashCode().)
Método público GetType (Herdado de Object.)
Método público Remove Removes a permission from the permission set.
Método públicoMembro estático Subtract Creates an object permission set by performing a subtraction operation on an IObjectPermission object and an ObjectPermissionSet object.
Método público ToString Returns the string value that represents the specified PermissionSetBase object. (Herdado de PermissionSetBase.)

Início

Operadores

  Nome Descrição
Operador públicoMembro estático Addition Creates an object permission set by performing an addition operation on an ObjectPermission object and an ObjectPermissionSet object.
Operador públicoMembro estático Equality Determines whether two objects are equal by performing an equality operation on two ObjectPermissionSet objects.
Operador públicoMembro estático Inequality Determines whether two objects are unequal by performing an inequality operation on two ObjectPermissionSet objects.
Operador públicoMembro estático Subtraction Creates an object permission set by performing a subtraction operation on an IObjectPermission object and an ObjectPermissionSet object.

Início

Comentários

Object permissions are required when granting, denying, or revoking permissions on an object. The ObjectPermissionSet object is required to specify the set of permissions that apply to the Grant method, the Deny method, and the Revoke method of the object.

Thread Safety

Qualquer membro público estático (Compartilhado no Microsoft Visual Basic) desse tipo é seguro para operações multi-threaded. Não há garantia de que qualquer membro de instância seja seguro para threads.

Exemplos

Concedendo, revogando e negando permissões

Segurança de thread

Qualquer membro público static (Shared no Visual Basic) desse tipo é seguro para threads. Não há garantia de que qualquer membro de instância seja seguro para threads.

Consulte também

Referência

Namespace Microsoft.SqlServer.Management.Smo