ObjectPermission Class

The ObjectPermission object represents a SQL Server object permission.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Smo.ObjectPermission

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

Syntax

'Declaration
Public NotInheritable Class ObjectPermission
'Usage
Dim instance As ObjectPermission

public sealed class ObjectPermission

public ref class ObjectPermission sealed

[<SealedAttribute>]
type ObjectPermission =  class end

public final class ObjectPermission

The ObjectPermission type exposes the following members.

Properties

	Name	Description
	Alter	Gets a permission that can be included in the object permission set.
	Connect	Gets a permission that can be included in the object permission set.
	Control	Gets a permission that can be included in the object permission set.
	Delete	Gets a permission that can be included in the object permission set.
	Execute	Gets a permission that can be included in the object permission set.
	Impersonate	Gets a permission that can be included in the object permission set.
	Insert	Gets a permission that can be included in the object permission set.
	Receive	Gets a permission that can be included in the object permission set.
	References	Gets a permission that can be included in the object permission set.
	Select	Gets a permission that can be included in the object permission set.
	Send	Gets a permission that can be included in the object permission set.
	TakeOwnership	Gets a permission that can be included in the object permission set.
	Update	Gets a permission that can be included in the object permission set.
	ViewChangeTracking	Gets a permission that can be included in the object permission set.
	ViewDefinition	Gets a permission that can be included in the object permission set.

Top

Methods

	Name	Description
	Add	Returns a set of object permissions after adding two object permissions.
	BitwiseOr	Returns an object permission set by performing a bitwise OR operation on two ObjectPermission objects.
	Equals	Determines if a ObjectPermission object is the same as the current ObjectPermission object. (Overrides Object.Equals(Object).)
	Finalize	(Inherited from Object.)
	GetHashCode	This method supports the SMO infrastructure and is not intended to be used directly from your code. (Overrides Object.GetHashCode().)
	GetType	(Inherited from Object.)
	MemberwiseClone	(Inherited from Object.)
	ToObjectPermissionSet	Converts an object permission into an object permission set.
	ToString	(Inherited from Object.)

Top

Operators

	Name	Description
	Addition	Creates an object permission set by performing an addition operation on two ObjectPermission objects.
	BitwiseOr	Creates an object permission set by performing a bitwise OR operation on two ObjectPermission objects.
	Equality	Creates an object permission set by performing an equality operation on two ObjectPermission objects.
	Implicit(ObjectPermission to ObjectPermissionSet)	Converts a single ObjectPermission to a ObjectPermissionSet
	Inequality	Creates an object permission set by performing an inequality operation on two ObjectPermission objects.

Top

Remarks

Object permissions are required when running granting, denying, or revoking permissions on an object. The ObjectPermission object is used to specify the set of permissions that apply to the Grant, Deny, and Revoke methods of the object. Also, object permissions can be added to the ObjectPermissionSet object, which can also be used with the Deny, Revoke, and Grant methods.

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.

Examples

Granting, Revoking, and Denying Permissions

Thread Safety

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

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace