Partager via


Classe ObjectPermissionSet

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

Hiérarchie d'héritage

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

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
Public NotInheritable Class ObjectPermissionSet _
    Inherits PermissionSetBase
'Utilisation
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

Le type ObjectPermissionSet expose les membres suivants.

Constructeurs

  Nom Description
Méthode publique ObjectPermissionSet() Initializes a new instance of the ObjectPermissionSet class.
Méthode publique ObjectPermissionSet(ObjectPermission) Initializes a new instance of the ObjectPermissionSet class based on the specified object permission.
Méthode publique ObjectPermissionSet(array<ObjectPermission[]) Initializes a new instance of the ObjectPermissionSet class based on the specified set of object permissions.
Méthode publique ObjectPermissionSet(ObjectPermissionSet) Initializes a new instance of the ObjectPermissionSet class based on the specified set of object permissions.

Haut de la page

Propriétés

  Nom Description
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.

Haut de la page

Méthodes

  Nom Description
Méthode publique Add(ObjectPermission) Returns an object permission set after adding a new object permission to the referenced permission set.
Méthode publiqueMembre statique Add(ObjectPermissionSet, ObjectPermission) Returns an object permission set after adding a new object permission to the referenced permission set.
Méthode publique Equals Determines whether the current ObjectPermissionSet object is equal to a specified object. (remplace PermissionSetBase.Equals(Object).)
Méthode publique GetHashCode This method supports the SQL Server infrastructure and is not intended to be used directly from your code. (remplace PermissionSetBase.GetHashCode().)
Méthode publique GetType (hérité de Object.)
Méthode publique Remove Removes a permission from the permission set.
Méthode publiqueMembre statique Subtract Creates an object permission set by performing a subtraction operation on an IObjectPermission object and an ObjectPermissionSet object.
Méthode publique ToString Returns the string value that represents the specified PermissionSetBase object. (hérité de PermissionSetBase.)

Haut de la page

Opérateurs

  Nom Description
Opérateur publicMembre statique Addition Creates an object permission set by performing an addition operation on an ObjectPermission object and an ObjectPermissionSet object.
Opérateur publicMembre statique Equality Determines whether two objects are equal by performing an equality operation on two ObjectPermissionSet objects.
Opérateur publicMembre statique Inequality Determines whether two objects are unequal by performing an inequality operation on two ObjectPermissionSet objects.
Opérateur publicMembre statique Subtraction Creates an object permission set by performing a subtraction operation on an IObjectPermission object and an ObjectPermissionSet object.

Haut de la page

Notes

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

Tout membre statique public (Partagé dans Microsoft Visual Basic) de ce type est sûr dans le cadre des opérations à plusieurs threads. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.

Exemples

Octroi, révocation et refus d'autorisations

Sécurité des threads

Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.

Voir aussi

Référence

Espace de noms Microsoft.SqlServer.Management.Smo