ObjectPermissionSet 클래스

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

네임스페이스:  Microsoft.SqlServer.Management.Smo
어셈블리:  Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)

구문

‘선언
Public NotInheritable Class ObjectPermissionSet _
    Inherits PermissionSetBase
‘사용 방법
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

ObjectPermissionSet 유형에서 다음 멤버를 표시합니다.

생성자

	이름	설명
	ObjectPermissionSet()	Initializes a new instance of the ObjectPermissionSet class.
	ObjectPermissionSet(ObjectPermission)	Initializes a new instance of the ObjectPermissionSet class based on the specified object permission.
	ObjectPermissionSet(array<ObjectPermission[])	Initializes a new instance of the ObjectPermissionSet class based on the specified set of object permissions.
	ObjectPermissionSet(ObjectPermissionSet)	Initializes a new instance of the ObjectPermissionSet class based on the specified set of object permissions.

맨 위로 이동

속성

	이름	설명
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.

맨 위로 이동

메서드

	이름	설명
	Add(ObjectPermission)	Returns an object permission set after adding a new object permission to the referenced permission set.
	Add(ObjectPermissionSet, ObjectPermission)	Returns an object permission set after adding a new object permission to the referenced permission set.
	Equals	Determines whether the current ObjectPermissionSet object is equal to a specified object. (PermissionSetBase.Equals(Object)을(를) 재정의함)
	GetHashCode	This method supports the SQL Server infrastructure and is not intended to be used directly from your code. (PermissionSetBase.GetHashCode()을(를) 재정의함)
	GetType	(Object에서 상속됨)
	Remove	Removes a permission from the permission set.
	Subtract	Creates an object permission set by performing a subtraction operation on an IObjectPermission object and an ObjectPermissionSet object.
	ToString	Returns the string value that represents the specified PermissionSetBase object. (PermissionSetBase에서 상속됨)

맨 위로 이동

연산자

	이름	설명
	Addition	Creates an object permission set by performing an addition operation on an ObjectPermission object and an ObjectPermissionSet object.
	Equality	Determines whether two objects are equal by performing an equality operation on two ObjectPermissionSet objects.
	Inequality	Determines whether two objects are unequal by performing an inequality operation on two ObjectPermissionSet objects.
	Subtraction	Creates an object permission set by performing a subtraction operation on an IObjectPermission object and an ObjectPermissionSet object.

맨 위로 이동

주의

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

이 유형의 모든 public static(Microsoft Visual Basic의 경우 공유) 멤버는 다중 스레드 작업을 수행하기에 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

예

권한 부여, 취소 및 거부

스레드 보안

이 유형의 모든 공용 static(Visual Basic에서는 Shared) 멤버는 스레드로부터 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

참고 항목

참조

Microsoft.SqlServer.Management.Smo 네임스페이스