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

ServerPermissionSet 클래스

The ServerPermissionSet object represents a set of server permissions.

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

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

public sealed class ServerPermissionSet : PermissionSetBase

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

  이름설명
공용 메서드ServerPermissionSet()Initializes a new instance of the ServerPermissionSet class.
공용 메서드ServerPermissionSet(ServerPermission)Initializes a new instance of the ServerPermissionSet class based on the specified permission.
공용 메서드ServerPermissionSet(ServerPermission[])Initializes a new instance of the ServerPermissionSet class based on the specified set of permissions.
공용 메서드ServerPermissionSet(ServerPermissionSet)Initializes a new instance of the ServerPermissionSet class based on the specified set of permissions.
맨 위로 이동

  이름설명
공용 속성AdministerBulkOperationsGets or sets the Boolean property value that specifies whether to include the ADMINISTER BULK OPERATIONS (ADBO) permission in the permission set. This permission lets the grantee perform bulk insert operations on the instance of SQL Server, such as importing data by using the bcp command, using the BULK INSERT statement, or using the INSERT…SELECT * FROM OPENROWSET(BULK…) statement.
공용 속성AlterAnyAvailabilityGroupGets or sets the Boolean property value that specifies whether to include the ALTER ANY AVAILABILITY GROUP permission in the permission set. This permission lets the grantee create, alter, or drop any availability group on the instance of SQL Server.
공용 속성AlterAnyConnectionGets or sets the Boolean property value that specifies whether to include the ALTER ANY CONNECTION (ALCO) permission in the permission set. This permission lets the grantee create, alter, or drop any connection on the instance of SQL Server.
공용 속성AlterAnyCredentialGets or sets the Boolean property value that specifies whether to include the ALTER ANY CREDENTIAL (ALCD) permission in the permission set. This permission lets the grantee create, alter, or drop any credential on the instance of SQL Server.
공용 속성AlterAnyDatabaseGets or sets the Boolean property value that specifies whether to include the ALTER ANY DATABASE (ALDB) permission in the permission set. This permission lets the grantee create, alter, or drop any database on the instance of SQL Server.
공용 속성AlterAnyEndpointGets or sets the Boolean property value that specifies whether to include the ALTER ANY ENDPOINT (ALHE) permission in the permission set. This permission lets the grantee create, alter, or drop any endpoint on the instance of SQL Server.
공용 속성AlterAnyEventNotificationGets or sets the Boolean property value that specifies whether to include the ALTER ANY EVENT NOTIFICATION (ALES) permission in the permission set. This permission lets the grantee to create, alter, or drop any event notification on the instance of SQL Server.
공용 속성AlterAnyEventSessionGets or sets the Boolean property value that specifies whether to include the ALTER ANY EVENT SESSION permission in the permission set. This permission lets the grantee create, alter, or drop any event session on the instance of SQL Server.
공용 속성AlterAnyLinkedServerGets or sets the Boolean property value that specifies whether to include the ALTER ANY LINKED SERVER (ALLS) permission in the permission set. This permission lets the grantee create, alter, or drop any linked server on the instance of SQL Server.
공용 속성AlterAnyLoginGets or sets the Boolean property value that specifies whether to include the ALTER ANY LOGIN (ALLG) permission in the permission set. This permission lets the grantee create, alter, or drop any login on the instance of SQL Server.
공용 속성AlterAnyServerAuditGets or sets the Boolean property value that specifies whether to include the ALTER ANY SERVER AUDIT permission in the permission set. This permission lets the grantee stop, start, or pause the instance of SQL Server.
공용 속성AlterAnyServerRoleGets or sets the Boolean property value that specifies whether to include the ALTER ANY SERVER ROLE permission in the permission set. This permission lets the grantee stop, start, or pause the instance of SQL Server.
공용 속성AlterResourcesGets or sets the Boolean property value that specifies whether to include the ALTER RESOURCES (ALRS) permission in the permission set. This permission lets the grantee create, alter, or drop any resource on the instance of SQL Server.
공용 속성AlterServerStateGets or sets the Boolean property value that specifies whether to include the ALTER SERVER STATE (ALSS) permission in the permission set. This permission lets the grantee stop, start, or pause the instance of SQL Server.
공용 속성AlterSettingsGets or sets the Boolean property value that specifies whether to include the ALTER SETTINGS (ASLT) permission in the permission set. This permission lets the grantee alter any settings on the instance of SQL Server, such as the default database directory.
공용 속성AlterTraceGets or sets the Boolean property value that specifies whether to include the ALTER TRACE (ALTR) permission in the permission set. This permission lets the grantee start, or stop trace runs or modify the trace options on the instance of SQL Server.
공용 속성AuthenticateServerGets or sets the Boolean property value that specifies whether to include the AUTHENTICATE SERVER permission in the permission set. This permission lets the grantee authenticate with the instance of SQL Server.
공용 속성ConnectSqlGets or sets the Boolean property value that specifies whether to include the CONNECT SQL (COSQ) permission in the permission set. This permission lets the grantee connect to the instance of SQL Server.
공용 속성ControlServerGets or sets the Boolean property value that specifies whether to include the CONTROL SERVER (CL) permission in the permission set. This permission lets the grantee grant any permission on any securable on the instance of SQL Server.
공용 속성CreateAnyDatabaseGets or sets the Boolean property value that specifies whether to include the CREATE ANY DATABASE (CRDB) permission in the permission set. This permission lets the grantee create, alter, or drop any database on the instance of SQL Server.
공용 속성CreateAvailabilityGroupGets or sets the Boolean property value that specifies whether to include the CREATE AVAILABILITY GROUP permission in the permission set. This permission lets the grantee create, alter, or drop availability group on the instance of SQL Server.
공용 속성CreateDdlEventNotificationGets or sets the Boolean property value that specifies whether to include the CREATE DDL EVENT NOTIFICATION (CRDE) permission in the permission set. This permission lets the grantee create any DDL (Data Definition Language) event notification on the instance of SQL Server, such as the event that is raised when a database is created.
공용 속성CreateEndpointGets or sets the Boolean property value that specifies whether to include the CREATE ENDPOINT (CRHE) permission in the permission set. This permission lets the grantee create endpoints on the instance of SQL Server for SOAP, Transact-SQL, database mirroring, and Service Broker.
공용 속성CreateServerRoleGets or sets the Boolean property value that specifies whether to include the CREATE SERVER ROLE permission in the permission set. This permission lets the grantee create server role on the instance of SQL Server.
공용 속성CreateTraceEventNotificationGets or sets the Boolean property value that specifies whether to include the CREATE TRACE EVENT NOTIFICATION (CRTE) permission in the permission set. This permission lets the grantee create trace event notifications on the instance of SQL Server.
공용 속성ExternalAccessAssemblyGets or sets the Boolean property value that specifies whether to include the EXTERNAL ACCESS (XA) permission in the permission set. This permission lets the grantee access external system resources such as assembly files, networks, environmental variables, and the registry.
공용 속성ShutdownGets or sets the Boolean property value that specifies whether to include the SHUTDOWN (SHDN) permission in the permission set. This permission lets the grantee stop the SQL Server service.
공용 속성UnsafeAssemblyGets or sets the Boolean property value that specifies whether to include the UNSAFE permission in the permission set. This permission allows the grantee unrestricted access to resources, both within and outside SQL Server, including calls to unmanaged code
공용 속성ViewAnyDatabaseGets or sets the Boolean property value that specifies whether to include the VIEW ANY DATABASE (VWDB) permission in the permission set. This permission lets the grantee view the definition (metadata) of any database on the instance of SQL Server.
공용 속성ViewAnyDefinitionGets or sets the Boolean property value that specifies whether to include the VIEW ANY DEFINITION (VWAD) permission in the permission set. This permission lets the grantee view the definition of any server that is securable on the instance of SQL Server.
공용 속성ViewServerStateGets or sets the Boolean property value that specifies whether to include the VIEW SERVER STATE (VWSS) permission in the permission set. This permission lets the grantee view the state of the instance of SQL Server.
맨 위로 이동

  이름설명
공용 메서드Add(ServerPermission)Returns a server permission set after adding a new server permission to the referenced permission set.
공용 메서드정적 멤버Add(ServerPermissionSet, ServerPermission)Returns a server permission set after adding a new server permission to the specified permission set.
공용 메서드EqualsDetermines whether the referenced server permission object is equal to a specified object. (PermissionSetBase.Equals(Object)을(를) 재정의함)
공용 메서드GetHashCode코드에서 직접 이 멤버를 참조하면 안 됩니다. 이 방법은 SQL Server 인프라를 지원합니다. (PermissionSetBase.GetHashCode()을(를) 재정의함)
공용 메서드GetType (Object에서 상속됨)
공용 메서드RemoveRemoves a permission from the permission set.
공용 메서드정적 멤버SubtractReturns a server permission set after subtracting a server permission from the specified permission set.
공용 메서드ToStringReturns the string value that represents the specified PermissionSetBase object. (PermissionSetBase에서 상속됨)
맨 위로 이동

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

Server permissions are required when you grant, deny, or revoke server-level permissions on an instance of SQL Server. The ServerPermissionSet object is required to specify the set of permissions that apply to the Grant method, the Deny method, and the Revoke method of the Server object.

Thread Safety

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

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

커뮤니티 추가 항목

추가
표시: