문서를 영문으로 보려면 영문 확인란을 선택하세요. 마우스 포인터를 텍스트 위로 이동시켜 팝업 창에서 영문 텍스트를 표시할 수도 있습니다.
번역
영문

DatabasePermissionSet 클래스

The DatabasePermissionSet object represents a SQL Server set of database permissions.

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

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

public sealed class DatabasePermissionSet : PermissionSetBase

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

  이름설명
공용 메서드DatabasePermissionSet()Initializes a new instance of the DatabasePermissionSet class.
공용 메서드DatabasePermissionSet(DatabasePermission)Initializes a new instance of the DatabasePermissionSet class.
공용 메서드DatabasePermissionSet(DatabasePermission[])Initializes a new instance of the DatabasePermissionSet class.
공용 메서드DatabasePermissionSet(DatabasePermissionSet)Initializes a new instance of the DatabasePermissionSet class.
맨 위로 이동

  이름설명
공용 속성AlterGets or sets the Boolean property value that specifies whether to include the ALTER permission in the permission set. This permission lets the grantee change the properties of the database, except ownership, and create, alter, or drop any child objects.
공용 속성AlterAnyApplicationRoleGets or sets the Boolean property value that specifies whether to include the ALTER ANY APPLICATION ROLE permission in the permission set. This permission lets the grantee change the properties of any application role in the database, except ownership.
공용 속성AlterAnyAssemblyGets or sets the Boolean property value that specifies whether to include the ALTER ANY ASSEMBLY permission in the permission set. This permission lets the grantee change the properties of any assembly in the database, except ownership.
공용 속성AlterAnyAsymmetricKeyGets or sets the Boolean property value that specifies whether to include the ALTER ANY ASYMMETRIC KEY permission in the permission set. This permission lets the grantee change the properties of any asymmetric key in the database, except ownership.
공용 속성AlterAnyCertificateGets or sets the Boolean property value that specifies whether to include the ALTER ANY CERTIFICATE permission in the permission set. This permission lets the grantee change the properties of any in the certificate in the database, except ownership.
공용 속성AlterAnyContractGets or sets the Boolean property value that specifies whether to include the ALTER ANY CONTRACT permission in the permission set. This permission lets the grantee change the properties of any Service Broker contract in the database, except ownership.
공용 속성AlterAnyDatabaseAuditGets or sets the Boolean property value that specifies whether to include the ALTER ANY DATABASE AUDIT permission in the permission set. This permission lets the grantee change modify the database audit objects.
공용 속성AlterAnyDatabaseDdlTriggerGets or sets the Boolean property value that specifies whether to include the ALTER ANY DATABASE DDL TRIGGER permission in the permission set. This permission lets the grantee change the properties of any database DDL trigger in the database, except ownership.
공용 속성AlterAnyDatabaseEventNotificationGets or sets the Boolean property value that specifies whether to include the ALTER ANY DATABASE EVENT NOTIFICATION permission in the permission set. This permission lets the grantee change the properties of any database event notification in the database, except ownership.
공용 속성AlterAnyDataspaceGets or sets the Boolean property value that specifies whether to include the ALTER ANY DATASPACE permission in the permission set. This permission lets the grantee change modify the database files.
공용 속성AlterAnyFulltextCatalogGets or sets the Boolean property value that specifies whether to include the ALTER ANY FULL TEXT CATALOG permission in the permission set. This permission lets the grantee change the properties of any Full Text catalog in the database, except ownership.
공용 속성AlterAnyMessageTypeGets or sets the Boolean property value that specifies whether to include the ALTER ANY MESSAGE TYPE permission in the permission set. This permission lets the grantee change the properties of any message type in the database, except ownership.
공용 속성AlterAnyRemoteServiceBindingGets or sets the Boolean property value that specifies whether to include the ALTER ANY REMOTE SERVICE BINDING permission in the permission set. This permission lets the grantee change the properties of any remote service binding in the database, except ownership.
공용 속성AlterAnyRoleGets or sets the Boolean property value that specifies whether to include the ALTER ANY ROLE permission in the permission set. This permission lets the grantee change the properties of any role in the database, except ownership.
공용 속성AlterAnyRouteGets or sets the Boolean property value that specifies whether to include the ALTER ANY ROUTE permission in the permission set. This permission lets the grantee change the properties of any Service Broker route in the database, except ownership.
공용 속성AlterAnySchemaGets or sets the Boolean property value that specifies whether to include the ALTER ANY SCHEMA permission in the permission set. This permission lets the grantee change the properties of any schema in the database, except ownership.
공용 속성AlterAnyServiceGets or sets the Boolean property value that specifies whether to include the ALTER ANY SERVICE permission in the permission set. This permission lets the grantee change the properties of any Service Broker service in the database, except ownership.
공용 속성AlterAnySymmetricKeyGets or sets the Boolean property value that specifies whether to include the ALTER ANY SYMMETRIC KEY permission in the permission set. This permission lets the grantee change the properties of any symmetric key in the database, except ownership.
공용 속성AlterAnyUserGets or sets the Boolean property value that specifies whether to include the ALTER ANY USER permission in the permission set. This permission lets the grantee change the properties of any user in the database, except ownership.
공용 속성AuthenticateGets or sets the Boolean property value that specifies whether to include the AUTHENTICATE permission in the permission set. This permission lets the grantee authenticate the database.
공용 속성BackupDatabaseGets or sets the Boolean property value that specifies whether to include the BACKUP DATABASE permission in the permission set. This permission lets the grantee create a backup of the database.
공용 속성BackupLogGets or sets the Boolean property value that specifies whether to include the BACKUP LOG permission in the permission set. This permission lets the grantee create a backup of the transaction log.
공용 속성CheckpointGets or sets the Boolean property value that specifies whether to include the CHECKPOINT permission in the permission set. This permission lets the grantee issue a checkpoint on the database.
공용 속성ConnectGets or sets the Boolean property value that specifies whether to include the CONNECT permission in the permission set. This permission lets the grantee connect to the database.
공용 속성ConnectReplicationGets or sets the Boolean property value that specifies whether to include the CONNECT REPLICATION permission in the permission set. This permission lets the grantee connect to replication databases.
공용 속성ControlGets or sets the Boolean property value that specifies whether to include the CONTROL permission in the permission set. This permission gives the grantee full control over the database, which includes every database permission.
공용 속성CreateAggregateGets or sets the Boolean property value that specifies whether to include the CREATE AGGREGATE permission in the permission set. This permission lets the grantee create an aggregate in the database.
공용 속성CreateAssemblyGets or sets the Boolean property value that specifies whether to include the CREATE ASSEMBLY permission in the permission set. This permission lets the grantee create an assembly in the database.
공용 속성CreateAsymmetricKeyGets or sets the Boolean property value that specifies whether to include the CREATE ASYMMETRIC KEY permission in the permission set. This permission lets the grantee create an asymmetric key.
공용 속성CreateCertificateGets or sets the Boolean property value that specifies whether to include the CREATE CERTIFICATE permission in the permission set. This permission lets the grantee create a certificate in the database.
공용 속성CreateContractGets or sets the Boolean property value that specifies whether to include the CREATE CONTRACT permission in the permission set. This permission lets the grantee create a Service Broker contract.
공용 속성CreateDatabaseGets or sets the Boolean property value that specifies whether to include the CREATE DATABASE permission in the permission set. This permission lets the grantee create the database.
공용 속성CreateDatabaseDdlEventNotificationGets or sets the Boolean property value that specifies whether to include the CREATE DATABASE DDL EVENT NOTIFICATION permission in the permission set. This permission lets the grantee create a database DDL event notification.
공용 속성CreateDefaultGets or sets the Boolean property value that specifies whether to include the CREATE DEFAULT permission in the permission set. This permission lets the grantee create a default in the database.
공용 속성CreateFulltextCatalogGets or sets the Boolean property value that specifies whether to include the CREATE FULL TEXT CATALOG permission in the permission set. This permission lets the grantee create a Full Text catalog in the database.
공용 속성CreateFunctionGets or sets the Boolean property value that specifies whether to include the CREATE FUNCTION permission in the permission set. This permission lets the grantee create a function in the database.
공용 속성CreateMessageTypeGets or sets the Boolean property value that specifies whether to include the CREATE MESSAGE TYPE permission in the permission set. This permission lets the grantee create a message type in the database.
공용 속성CreateProcedureGets or sets the Boolean property value that specifies whether to include the CREATE PROCEDURE permission in the permission set. This permission lets the grantee create a stored procedure in the database.
공용 속성CreateQueueGets or sets the Boolean property value that specifies whether to include the CREATE QUEUE permission in the permission set. This permission lets the grantee create a Service Broker queue in the database.
공용 속성CreateRemoteServiceBindingGets or sets the Boolean property value that specifies whether to include the CREATE REMOTE SERVICE BINDING permission in the permission set. This permission lets the grantee create a remote service binding in the database.
공용 속성CreateRoleGets or sets the Boolean property value that specifies whether to include the CREATE ROLE permission in the permission set. This permission lets the grantee create a database role.
공용 속성CreateRouteGets or sets the Boolean property value that specifies whether to include the CREATE ROUTE permission in the permission set. This permission lets the grantee create a Service Broker route in the database.
공용 속성CreateRuleGets or sets the Boolean property value that specifies whether to include the CREATE RULE permission in the permission set. This permission lets the grantee create a rule in the database.
공용 속성CreateSchemaGets or sets the Boolean property value that specifies whether to include the CREATE SCHEMA permission in the permission set. This permission lets the grantee create a schema in the database.
공용 속성CreateServiceGets or sets the Boolean property value that specifies whether to include the CREATE SERVICE permission in the permission set. This permission lets the grantee create a Service Broker service in the database.
공용 속성CreateSymmetricKeyGets or sets the Boolean property value that specifies whether to include the CREATE SYMMETRIC KEY permission in the permission set. This permission lets the grantee create a symmetric key in the database.
공용 속성CreateSynonymGets or sets the Boolean property value that specifies whether to include the CREATE SYNONYM permission in the permission set. This permission lets the grantee create a synonym in the database.
공용 속성CreateTableGets or sets the Boolean property value that specifies whether to include the CREATE TABLE permission in the permission set. This permission lets the grantee create a table in the database.
공용 속성CreateTypeGets or sets the Boolean property value that specifies whether to include the CREATE TYPE permission in the permission set. This permission lets the grantee create a type in the database.
공용 속성CreateViewGets or sets the Boolean property value that specifies whether to include the CREATE VIEW permission in the permission set. This permission lets the grantee create a view in the database.
공용 속성CreateXmlSchemaCollectionGets or sets the Boolean property value that specifies whether to include the CREATE XML SCHEMA COLLECTION permission in the permission set. This permission lets the grantee create an XML schema collection in the database.
공용 속성DeleteGets or sets the Boolean property value that specifies whether to include the DELETE permission in the permission set. This permission lets the grantee remove data from the database.
공용 속성ExecuteGets or sets the Boolean property value that specifies whether to include the EXECUTE permission in the permission set. This permission lets the grantee execute stored procedures and functions in the database.
공용 속성InsertGets or sets the Boolean property value that specifies whether to include the INSERT permission in the permission set. This permission lets the grantee add data to the database.
공용 속성ReferencesGets or sets the Boolean property value that specifies whether to include the REFERENCES permission in the permission set. This permission lets the grantee reference the database.
공용 속성SelectGets 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 in the database.
공용 속성ShowplanGets or sets the Boolean property value that specifies whether to include the SHOWPLAN permission in the permission set. This permission lets the grantee view the execution plan for stored procedures in the database.
공용 속성SubscribeQueryNotificationsGets or sets the Boolean property value that specifies whether to include the SUBSCRIBE QUERY NOTIFICATIONS permission in the permission set. This permission lets the grantee subscribe to Service Broker query notifications.
공용 속성TakeOwnershipGets 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 database.
공용 속성UpdateGets or sets the Boolean property value that specifies whether to include the UPDATE permission in the permission set. This permission lets the grantee update the data in the database.
공용 속성ViewDatabaseStateGets or sets the Boolean property value that specifies whether to include the VIEW DATABASE STATE permission in the permission set. This permission lets the grantee view the state of the database.
공용 속성ViewDefinitionGets 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 database.
맨 위로 이동

  이름설명
공용 메서드Add(DatabasePermission)Returns a database permission set after adding a new a database permission to the referenced permission set.
공용 메서드정적 멤버Add(DatabasePermissionSet, DatabasePermission)Returns a database permission set after adding a new a database permission to the specified permission set.
공용 메서드EqualsDetermines whether the referenced database permission object is equal to a specified object. (PermissionSetBase.Equals(Object)을(를) 재정의함)
공용 메서드GetHashCodeThis method supports the SQL Server infrastructure and is not intended to be used directly from your code. (PermissionSetBase.GetHashCode()을(를) 재정의함)
공용 메서드GetType (Object에서 상속됨)
공용 메서드RemoveRemoves a permission from the permission set.
공용 메서드정적 멤버SubtractReturns a database permission set after removing a database permission from the specified permission set.
공용 메서드ToStringReturns the string value that represents the specified PermissionSetBase object. (PermissionSetBase에서 상속됨)
맨 위로 이동

  이름설명
공용 연산자정적 멤버AdditionCreates a database permission set by performing an addition operation on a DatabasePermission object and a DatabasePermissionSet object.
공용 연산자정적 멤버EqualityDetermines whether two DatabasePermissionSet objects are equal.
공용 연산자정적 멤버InequalityDetermines whether two objects are unequal by performing an inequality operation on two DatabasePermissionSet objects.
공용 연산자정적 멤버SubtractionCreates a database permission set by performing a subtraction operation on a DatabasePermission object and a DatabasePermissionSet object.
맨 위로 이동

Database permissions are required when running granting, denying, or revoking permissions on a database. The DatabasePermissionSet object is required to specify the set of permissions that apply to the Grant method, the Deny method, and the Revoke method of the Database object.

Thread Safety

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

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

커뮤니티 추가 항목

추가
표시: