DatabasePermission 클래스

The DatabasePermission object represents a SQL Server database permission. The database permission can be added to a database permission set, and then granted, revoked, or denied to a user.

상속 계층

System.Object
  Microsoft.SqlServer.Management.Smo.DatabasePermission

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

구문

‘선언
Public NotInheritable Class DatabasePermission
‘사용 방법
Dim instance As DatabasePermission

public sealed class DatabasePermission

public ref class DatabasePermission sealed

[<SealedAttribute>]
type DatabasePermission =  class end

public final class DatabasePermission

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

속성

	이름	설명
	Alter	Gets a permission that can be included in the database permission set.
	AlterAnyApplicationRole	Gets a permission that can be included in the database permission set.
	AlterAnyAssembly	Gets a permission that can be included in the database permission set.
	AlterAnyAsymmetricKey	Gets a permission that can be included in the database permission set.
	AlterAnyCertificate	Gets a permission that can be included in the database permission set.
	AlterAnyContract	Gets a permission that can be included in the database permission set.
	AlterAnyDatabaseAudit	Gets a permission that can be included in the database permission set.
	AlterAnyDatabaseDdlTrigger	Gets a permission that can be included in the database permission set.
	AlterAnyDatabaseEventNotification	Gets a permission that can be included in the database permission set.
	AlterAnyDataspace	Gets a permission that can be included in the database permission set.
	AlterAnyFulltextCatalog	Gets a permission that can be included in the database permission set.
	AlterAnyMessageType	Gets a permission that can be included in the database permission set.
	AlterAnyRemoteServiceBinding	Gets a permission that can be included in the database permission set.
	AlterAnyRole	Gets a permission that can be included in the database permission set.
	AlterAnyRoute	Gets a permission that can be included in the database permission set.
	AlterAnySchema	Gets a permission that can be included in the database permission set.
	AlterAnyService	Gets a permission that can be included in the database permission set.
	AlterAnySymmetricKey	Gets a permission that can be included in the database permission set.
	AlterAnyUser	Gets a permission that can be included in the database permission set.
	Authenticate	Gets a permission that can be included in the database permission set.
	BackupDatabase	Gets a permission that can be included in the database permission set.
	BackupLog	Gets a permission that can be included in the database permission set.
	Checkpoint	Gets a permission that can be included in the database permission set.
	Connect	Gets a permission that can be included in the database permission set.
	ConnectReplication	Gets a permission that can be included in the database permission set.
	Control	Gets a permission that can be included in the database permission set.
	CreateAggregate	Gets a permission that can be included in the database permission set.
	CreateAssembly	Gets a permission that can be included in the database permission set.
	CreateAsymmetricKey	Gets a permission that can be included in the database permission set.
	CreateCertificate	Gets a permission that can be included in the database permission set.
	CreateContract	Gets a permission that can be included in the database permission set.
	CreateDatabase	Gets a permission that can be included in the database permission set.
	CreateDatabaseDdlEventNotification	Gets a permission that can be included in the database permission set.
	CreateDefault	Gets a permission that can be included in the database permission set.
	CreateFulltextCatalog	Gets a permission that can be included in the database permission set.
	CreateFunction	Gets a permission that can be included in the database permission set.
	CreateMessageType	Gets a permission that can be included in the database permission set.
	CreateProcedure	Gets a permission that can be included in the database permission set.
	CreateQueue	Gets a permission that can be included in the database permission set.
	CreateRemoteServiceBinding	Gets a permission that can be included in the database permission set.
	CreateRole	Gets a permission that can be included in the database permission set.
	CreateRoute	Gets a permission that can be included in the database permission set.
	CreateRule	Gets a permission that can be included in the database permission set.
	CreateSchema	Gets a permission that can be included in the database permission set.
	CreateService	Gets a permission that can be included in the database permission set.
	CreateSymmetricKey	Gets a permission that can be included in the database permission set.
	CreateSynonym	Gets a permission that can be included in the database permission set.
	CreateTable	Gets a permission that can be included in the database permission set.
	CreateType	Gets a permission that can be included in the database permission set.
	CreateView	Gets a permission that can be included in the database permission set.
	CreateXmlSchemaCollection	Gets a permission that can be included in the database permission set.
	Delete	Gets a permission that can be included in the database permission set.
	Execute	Gets a permission that can be included in the database permission set.
	Insert	Gets a permission that can be included in the database permission set.
	References	Gets a permission that can be included in the database permission set.
	Select	Gets a permission that can be included in the database permission set.
	Showplan	Gets a permission that can be included in the database permission set.
	SubscribeQueryNotifications	Gets a permission that can be included in the database permission set.
	TakeOwnership	Gets a permission that can be included in the database permission set.
	Update	Gets a permission that can be included in the database permission set.
	ViewDatabaseState	Gets a permission that can be included in the database permission set.
	ViewDefinition	Gets a permission that can be included in the database permission set.

맨 위로 이동

메서드

	이름	설명
	Add	Returns a set of database permissions after adding a new database permission to an existing set of database permissions.
	BitwiseOr	Creates a database permission set by performing a bitwise OR operation on two DatabasePermission objects.
	Equals	Determines whether the referenced database permission object is equal to a specified object. (Object.Equals(Object)을(를) 재정의함)
	GetHashCode	This method supports the SQL Server infrastructure and is not intended to be used directly from your code. (Object.GetHashCode()을(를) 재정의함)
	GetType	(Object에서 상속됨)
	ToDatabasePermissionSet	Returns a set of database permissions, based on a single database permission, by converting a DatabasePermission object to a DatabasePermissionSet object.
	ToString	(Object에서 상속됨)

맨 위로 이동

연산자

	이름	설명
	Addition	Creates a database permission set by performing an addition operation on two DatabasePermission objects.
	BitwiseOr	Creates a database permission set by performing a bitwise OR operation on two DatabasePermission objects.
	Equality	Compares two DatabasePermission objects in an equality operation.
	Implicit(DatabasePermission to DatabasePermissionSet)	Converts a single database permission object to a database permission set.
	Inequality	Determines whether two DatabasePermission objects are not equal by performing an inequality operation.

맨 위로 이동

주의

Database permissions are required when running granting, denying, or revoking permissions on a database. The DatabasePermission object is used to specify the set of permissions that apply to the Grant, Deny, and Revoke methods of the Database object. Also, database permissions can be added to the DatabasePermissionSet object, which can also be used with the Grant, Deny, and Revoke methods.

Thread Safety

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

예

권한 부여, 취소 및 거부

스레드 보안

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

참고 항목

참조

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

관련 자료

사용 권한(데이터베이스 엔진)