Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

ObjectPermissionSet Class

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

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

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
public final class ObjectPermissionSet extends PermissionSetBase

The ObjectPermissionSet type exposes the following members.

  NameDescription
Public methodObjectPermissionSet()Initializes a new instance of the ObjectPermissionSet class.
Public methodObjectPermissionSet(ObjectPermission)Initializes a new instance of the ObjectPermissionSet class based on the specified object permission.
Public methodObjectPermissionSet(ObjectPermission[])Initializes a new instance of the ObjectPermissionSet class based on the specified set of object permissions.
Public methodObjectPermissionSet(ObjectPermissionSet)Initializes a new instance of the ObjectPermissionSet class based on the specified set of object permissions.
Top
  NameDescription
Public propertyAlterGets 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.
Public propertyConnectGets 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.
Public propertyControlGets 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.
Public propertyCreateSequenceGets 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.
Public propertyDeleteGets 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.
Public propertyExecuteGets 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.
Public propertyImpersonateGets 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.
Public propertyInsertGets 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.
Public propertyReceiveGets 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.
Public propertyReferencesGets 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.
Public propertySelectGets 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.
Public propertySendGets 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.
Public propertyTakeOwnershipGets 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.
Public propertyUpdateGets 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.
Public propertyViewChangeTrackingGets 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.
Public propertyViewDefinitionGets 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
  NameDescription
Public methodAdd(ObjectPermission)Returns an object permission set after adding a new object permission to the referenced permission set.
Public methodStatic memberAdd(ObjectPermissionSet, ObjectPermission)Returns an object permission set after adding a new object permission to the referenced permission set.
Public methodEqualsDetermines whether the current ObjectPermissionSet object is equal to a specified object. (Overrides PermissionSetBase.Equals(Object).)
Public methodGetHashCodeThis method supports the SQL Server infrastructure and is not intended to be used directly from your code. (Overrides PermissionSetBase.GetHashCode().)
Public methodGetType (Inherited from Object.)
Public methodRemoveRemoves a permission from the permission set.
Public methodStatic memberSubtractCreates an object permission set by performing a subtraction operation on an IObjectPermission object and an ObjectPermissionSet object.
Public methodToStringReturns the string value that represents the specified PermissionSetBase object. (Inherited from PermissionSetBase.)
Top
  NameDescription
Public operatorStatic memberAdditionCreates an object permission set by performing an addition operation on an ObjectPermission object and an ObjectPermissionSet object.
Public operatorStatic memberEqualityDetermines whether two objects are equal by performing an equality operation on two ObjectPermissionSet objects.
Public operatorStatic memberInequalityDetermines whether two objects are unequal by performing an inequality operation on two ObjectPermissionSet objects.
Public operatorStatic memberSubtractionCreates an object permission set by performing a subtraction operation on an IObjectPermission object and an ObjectPermissionSet object.
Top

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

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.