Share via


ObjectPermissionSet Members

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

The following tables list the members exposed by the ObjectPermissionSet type.

Public Constructors

  Name Description
ObjectPermissionSet Overloaded. Initializes a new instance of the ObjectPermissionSet class.

Top

Public Properties

  Name Description
ms219859.pubproperty(en-US,SQL.90).gif 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.
ms219859.pubproperty(en-US,SQL.90).gif 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.
ms219859.pubproperty(en-US,SQL.90).gif 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.
ms219859.pubproperty(en-US,SQL.90).gif 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.
ms219859.pubproperty(en-US,SQL.90).gif 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.
ms219859.pubproperty(en-US,SQL.90).gif 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.
ms219859.pubproperty(en-US,SQL.90).gif 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.
ms219859.pubproperty(en-US,SQL.90).gif 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.
ms219859.pubproperty(en-US,SQL.90).gif 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.
ms219859.pubproperty(en-US,SQL.90).gif 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.
ms219859.pubproperty(en-US,SQL.90).gif 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.
ms219859.pubproperty(en-US,SQL.90).gif 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.
ms219859.pubproperty(en-US,SQL.90).gif 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.
ms219859.pubproperty(en-US,SQL.90).gif 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.

Top

Public Methods

(see also Protected Methods )

  Name Description
ms219859.pubmethod(en-US,SQL.90).gif Add Overloaded. Returns an object permission set after adding a new object permission to the specified permission set.
ms219859.pubmethod(en-US,SQL.90).gif Equals Overloaded. Overridden.  
ms219859.pubmethod(en-US,SQL.90).gif GetHashCode Overridden. This method supports the SQL Server infrastructure. It is not intended to be used directly from your code.
ms219859.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms219859.pubmethod(en-US,SQL.90).gifms219859.static(en-US,SQL.90).gif op_Addition Creates an object permission set by performing an addition operation on an ObjectPermission object and an ObjectPermissionSet object.
ms219859.pubmethod(en-US,SQL.90).gifms219859.static(en-US,SQL.90).gif op_Equality Determines whether two objects are equal by performing an equality operation on two ObjectPermissionSet objects.
ms219859.pubmethod(en-US,SQL.90).gifms219859.static(en-US,SQL.90).gif op_Inequality Determines whether two objects are unequal by performing an inequality operation on two ObjectPermissionSet objects.
ms219859.pubmethod(en-US,SQL.90).gifms219859.static(en-US,SQL.90).gif op_Subtraction Creates an object permission set by performing a subtraction operation on an IObjectPermission object and an ObjectPermissionSet object.
ms219859.pubmethod(en-US,SQL.90).gifms219859.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms219859.pubmethod(en-US,SQL.90).gif Remove Removes a permission from the permission set.
ms219859.pubmethod(en-US,SQL.90).gifms219859.static(en-US,SQL.90).gif Subtract Creates an object permission set by performing a subtraction operation on an IObjectPermission object and an ObjectPermissionSet object.
ms219859.pubmethod(en-US,SQL.90).gif ToString  Returns the string value that represents the specified PermissionSetBase object. (inherited from PermissionSetBase)

Top

Protected Methods

  Name Description
ms219859.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms219859.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

See Also

Reference

ObjectPermissionSet Class
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Granting, Revoking, and Denying Permissions