sys.fn_builtin_permissions(Transact-SQL)sys.fn_builtin_permissions (Transact-SQL)

이 항목은 다음에 적용됩니다.예SQL Server(2008부터)예Azure SQL Database아니요Azure SQL Data Warehouse 아니요병렬 데이터 웨어하우스 THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

서버의 기본 제공 사용 권한 계층에 대한 설명을 반환합니다.Returns a description of the built in permissions hierarchy of the server. sys.fn_builtin_permissions에 호출할 수 SQL ServerSQL ServerAzure SQL 데이터베이스Azure SQL Database, 현재 플랫폼에서 지원 되는지 여부에 관계 없이 모든 사용 권한을 반환 합니다.sys.fn_builtin_permissions can only be called on SQL ServerSQL Server and Azure SQL 데이터베이스Azure SQL Database, and it returns all permissions regardless of whether they are supported on the current platform. 대부분의 권한은 모든 플랫폼에 적용되지만 그렇지 않은 경우도 있습니다.Most permissions apply to all platforms, but some do not. 예를 들어 서버 수준 사용 권한은 SQL 데이터베이스에 부여할 수 없습니다.For example server level permissions cannot be granted on SQL Database. 플랫폼에서 각 사용 권한에 대 한 지원 정보를 참조 하십시오. 사용 권한 ( 데이터베이스 엔진 )합니다.For information about which platforms support each permission, see Permissions (Database Engine).

항목 링크 아이콘 Transact-SQL 구문 규칙Topic link icon Transact-SQL Syntax Conventions

구문Syntax


sys.fn_builtin_permissions ( [ DEFAULT | NULL ]  
    | empty_string | '<securable_class>' } )  

<securable_class> ::=   
      APPLICATION ROLE | ASSEMBLY | ASYMMETRIC KEY | AVAILABILITY GROUP  
    | CERTIFICATE | CONTRACT | DATABASE | DATABASE SCOPED CREDENTIAL    
    | ENDPOINT | FULLTEXT CATALOG | FULLTEXT STOPLIST | LOGIN      
    | MESSAGE TYPE | OBJECT | REMOTE SERVICE BINDING | ROLE | ROUTE    
    | SCHEMA | SEARCH PROPERTY LIST | SERVER | SERVER ROLE | SERVICE    
    | SYMMETRIC KEY | TYPE | USER | XML SCHEMA COLLECTION  

인수Arguments

DEFAULTDEFAULT
(따옴표 제외) 기본 옵션으로 호출 될 때 전체 기본 제공된 사용 권한 목록을 반환 합니다.When it is called with the DEFAULT option (without quotes), the function will return a complete list of built in permissions.

NULLNULL
DEFAULT와 동일합니다.Equivalent to DEFAULT.

empty_stringempty_string
DEFAULT와 동일합니다.Equivalent to DEFAULT.

'<securable_class>''<securable_class>'
특정 보안 개체 클래스의 이름으로 호출할 때 sys.fn_builtin_permissions 클래스에 적용 되는 모든 사용 권한을 반환 합니다.When it is called with the name of one securable class, sys.fn_builtin_permissions will return all permissions that apply to the class. < l e _ >는 따옴표로 묶어야 하는 문자열 리터럴입니다.<securable_class> is a string literal that requires quotation marks. nvarchar(60)nvarchar(60)

반환된 테이블Tables Returned

열 이름Column name 데이터 형식Data type 데이터 정렬Collation DescriptionDescription
class_descclass_desc nvarchar(60)nvarchar(60) 서버의 데이터 정렬Collation of the server 보안 개체 클래스에 대한 설명입니다.Description of the securable class.
permission_namepermission_name nvarchar(60)nvarchar(60) 서버의 데이터 정렬Collation of the server 사용 권한 이름입니다.Permission name.
유형type varchar(4)varchar(4) 서버의 데이터 정렬Collation of the server 단축 사용 권한 유형 코드입니다.Compact permission type code. 다음 표를 참조하십시오.See the table that follows.
covering_permission_namecovering_permission_name nvarchar(60)nvarchar(60) 서버의 데이터 정렬Collation of the server NULL이 아니면 이 클래스에 대한 다른 사용 권한을 포함하는 사용 권한의 이름입니다.If not NULL, this is the name of the permission on this class that implies the other permissions on this class.
parent_class_descparent_class_desc nvarchar(60)nvarchar(60) 서버의 데이터 정렬Collation of the server NULL이 아니면 현재 클래스를 포함하는 부모 클래스의 이름입니다.If not NULL, this is the name of the parent class that contains the current class.
parent_covering_permission_nameparent_covering_permission_name nvarchar(60)nvarchar(60) 서버의 데이터 정렬Collation of the server NULL이 아니면 부모 클래스에 대한 다른 모든 사용 권한을 포함하는 사용 권한의 이름입니다.If not NULL, this is the name of the permission on the parent class that implies all other permissions on that class.

사용 권한 유형Permission Types

사용 권한 유형Permission type 사용 권한 이름Permission name 적용되는 보안 개체 또는 클래스Applies to securable or class
AADSAADS ALTER ANY DATABASE EVENT SESSIONALTER ANY DATABASE EVENT SESSION
적용 대상: SQL ServerSQL Server ( SQL Server 2014SQL Server 2014 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2014SQL Server 2014 through current version).
DATABASEDATABASE
AAESAAES ALTER ANY EVENT SESSIONALTER ANY EVENT SESSION SERVERSERVER
AAMKAAMK ALTER ANY MASKALTER ANY MASK
적용 대상: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 through current version).
DATABASEDATABASE
ADBOADBO ADMINISTER BULK OPERATIONSADMINISTER BULK OPERATIONS SERVERSERVER
AEDSAEDS ALTER ANY EXTERNAL DATA SOURCEALTER ANY EXTERNAL DATA SOURCE
적용 대상: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 through current version).
DATABASEDATABASE
AEFFAEFF ALTER ANY EXTERNAL FILE FORMATALTER ANY EXTERNAL FILE FORMAT
적용 대상: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 through current version).
DATABASEDATABASE
ALAL ALTERALTER APPLICATION ROLEAPPLICATION ROLE
ALAL ALTERALTER ASSEMBLYASSEMBLY
ALAL ALTERALTER
적용 대상: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 through current version).
AVAILABILITY GROUPAVAILABILITY GROUP
ALAL ALTERALTER ASYMMETRIC KEYASYMMETRIC KEY
ALAL ALTERALTER CERTIFICATECERTIFICATE
ALAL ALTERALTER CONTRACTCONTRACT
ALAL ALTERALTER DATABASEDATABASE
ALAL ALTERALTER
T o 적용: SQL Server 2017SQL Server 2017SQL 데이터베이스SQL Database합니다.Applies t o: SQL Server 2017SQL Server 2017 and SQL 데이터베이스SQL Database.
DATABASE SCOPED CREDENTIALDATABASE SCOPED CREDENTIAL
ALAL ALTERALTER ENDPOINTENDPOINT
ALAL ALTERALTER FULLTEXT CATALOGFULLTEXT CATALOG
ALAL ALTERALTER FULLTEXT STOPLISTFULLTEXT STOPLIST
ALAL ALTERALTER LoginLOGIN
ALAL ALTERALTER MESSAGE TYPEMESSAGE TYPE
ALAL ALTERALTER OBJECTOBJECT
ALAL ALTERALTER REMOTE SERVICE BINDINGREMOTE SERVICE BINDING
ALAL ALTERALTER ROLEROLE
ALAL ALTERALTER ROUTEROUTE
ALAL ALTERALTER SCHEMASCHEMA
ALAL ALTERALTER SEARCH PROPERTY LISTSEARCH PROPERTY LIST
ALAL ALTERALTER
적용 대상: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 through current version).
SERVER ROLESERVER ROLE
ALAL ALTERALTER SERVICESERVICE
ALAL ALTERALTER SYMMETRIC KEYSYMMETRIC KEY
ALAL ALTERALTER USERUSER
ALAL ALTERALTER XML SCHEMA COLLECTIONXML SCHEMA COLLECTION
ALAAALAA ALTER ANY SERVER AUDITALTER ANY SERVER AUDIT SERVERSERVER
ALAGALAG ALTER ANY AVAILABILITY GROUPALTER ANY AVAILABILITY GROUP
적용 대상: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 through current version).
SERVERSERVER
ALAKALAK ALTER ANY ASYMMETRIC KEYALTER ANY ASYMMETRIC KEY DATABASEDATABASE
ALARALAR ALTER ANY APPLICATION ROLEALTER ANY APPLICATION ROLE DATABASEDATABASE
ALASALAS ALTER ANY ASSEMBLYALTER ANY ASSEMBLY DATABASEDATABASE
ALCDALCD ALTER ANY CREDENTIALALTER ANY CREDENTIAL SERVERSERVER
ALCFALCF ALTER ANY CERTIFICATEALTER ANY CERTIFICATE DATABASEDATABASE
ALCKALCK ALTER ANY COLUMN ENCRYPTION KEYALTER ANY COLUMN ENCRYPTION KEY
적용 대상: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 through current version).
DATABASEDATABASE
ALCMALCM ALTER ANY COLUMN MASTER KEYALTER ANY COLUMN MASTER KEY
적용 대상: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 through current version).
DATABASEDATABASE
ALCOALCO ALTER ANY CONNECTIONALTER ANY CONNECTION SERVERSERVER
ALDAALDA ALTER ANY DATABASE AUDITALTER ANY DATABASE AUDIT DATABASEDATABASE
ALDBALDB ALTER ANY DATABASEALTER ANY DATABASE SERVERSERVER
ALDCALDC ALTER ANY DATABASE SCOPED CONFIGURATIONALTER ANY DATABASE SCOPED CONFIGURATION
적용 대상: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 through current version).
DATABASEDATABASE
ALDSALDS ALTER ANY DATASPACEALTER ANY DATASPACE DATABASEDATABASE
ALEDALED ALTER ANY DATABASE EVENT NOTIFICATIONALTER ANY DATABASE EVENT NOTIFICATION DATABASEDATABASE
ALESALES ALTER ANY EVENT NOTIFICATIONALTER ANY EVENT NOTIFICATION SERVERSERVER
ALFTALFT ALTER ANY FULLTEXT CATALOGALTER ANY FULLTEXT CATALOG DATABASEDATABASE
ALHEALHE ALTER ANY ENDPOINTALTER ANY ENDPOINT SERVERSERVER
ALLGALLG ALTER ANY LOGINALTER ANY LOGIN SERVERSERVER
ALLSALLS ALTER ANY LINKED SERVERALTER ANY LINKED SERVER SERVERSERVER
ALMTALMT ALTER ANY MESSAGE TYPEALTER ANY MESSAGE TYPE DATABASEDATABASE
ALRLALRL ALTER ANY ROLEALTER ANY ROLE DATABASEDATABASE
ALRSALRS ALTER RESOURCESALTER RESOURCES SERVERSERVER
ALRTALRT ALTER ANY ROUTEALTER ANY ROUTE DATABASEDATABASE
ALSBALSB ALTER ANY REMOTE SERVICE BINDINGALTER ANY REMOTE SERVICE BINDING DATABASEDATABASE
ALSCALSC ALTER ANY CONTRACTALTER ANY CONTRACT DATABASEDATABASE
ALSKALSK ALTER ANY SYMMETRIC KEYALTER ANY SYMMETRIC KEY DATABASEDATABASE
ALSMALSM ALTER ANY SCHEMAALTER ANY SCHEMA DATABASEDATABASE
ALSPALSP ALTER ANY SECURITY POLICYALTER ANY SECURITY POLICY
적용 대상: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 through current version).
DATABASEDATABASE
ALSRALSR ALTER ANY SERVER ROLEALTER ANY SERVER ROLE
적용 대상: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 through current version).
SERVERSERVER
ALSSALSS ALTER SERVER STATEALTER SERVER STATE SERVERSERVER
ALSTALST ALTER SETTINGSALTER SETTINGS SERVERSERVER
ALSVALSV ALTER ANY SERVICEALTER ANY SERVICE DATABASEDATABASE
ALTGALTG ALTER ANY DATABASE DDL TRIGGERALTER ANY DATABASE DDL TRIGGER DATABASEDATABASE
ALTRALTR ALTER TRACEALTER TRACE SERVERSERVER
ALUSALUS ALTER ANY USERALTER ANY USER DATABASEDATABASE
AUTHAUTH AUTHENTICATEAUTHENTICATE DATABASEDATABASE
AUTHAUTH AUTHENTICATE SERVERAUTHENTICATE SERVER SERVERSERVER
BADBBADB BACKUP DATABASEBACKUP DATABASE DATABASEDATABASE
BALOBALO BACKUP LOGBACKUP LOG DATABASEDATABASE
CADBCADB CONNECT ANY DATABASECONNECT ANY DATABASE
적용 대상: SQL ServerSQL Server ( SQL Server 2014SQL Server 2014 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2014SQL Server 2014 through current version).
SERVERSERVER
CLCL CONTROLCONTROL APPLICATION ROLEAPPLICATION ROLE
CLCL CONTROLCONTROL ASSEMBLYASSEMBLY
CLCL CONTROLCONTROL ASYMMETRIC KEYASYMMETRIC KEY
CLCL CONTROLCONTROL
적용 대상: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 through current version).
AVAILABILITY GROUPAVAILABILITY GROUP
CLCL CONTROLCONTROL CERTIFICATECERTIFICATE
CLCL CONTROLCONTROL CONTRACTCONTRACT
CLCL CONTROLCONTROL DATABASEDATABASE
CLCL CONTROLCONTROL
적용 대상: SQL Server 2017SQL Server 2017SQL 데이터베이스SQL Database합니다.Applies to: SQL Server 2017SQL Server 2017 and SQL 데이터베이스SQL Database.
DATABASE SCOPED CREDENTIALDATABASE SCOPED CREDENTIAL
CLCL CONTROLCONTROL ENDPOINTENDPOINT
CLCL CONTROLCONTROL FULLTEXT CATALOGFULLTEXT CATALOG
CLCL CONTROLCONTROL FULLTEXT STOPLISTFULLTEXT STOPLIST
CLCL CONTROLCONTROL LoginLOGIN
CLCL CONTROLCONTROL MESSAGE TYPEMESSAGE TYPE
CLCL CONTROLCONTROL OBJECTOBJECT
CLCL CONTROLCONTROL REMOTE SERVICE BINDINGREMOTE SERVICE BINDING
CLCL CONTROLCONTROL ROLEROLE
CLCL CONTROLCONTROL ROUTEROUTE
CLCL CONTROLCONTROL SCHEMASCHEMA
CLCL CONTROLCONTROL SEARCH PROPERTY LISTSEARCH PROPERTY LIST
CLCL CONTROL SERVERCONTROL SERVER SERVERSERVER
CLCL CONTROLCONTROL
적용 대상: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 through current version).
SERVER ROLESERVER ROLE
CLCL CONTROLCONTROL SERVICESERVICE
CLCL CONTROLCONTROL SYMMETRIC KEYSYMMETRIC KEY
CLCL CONTROLCONTROL TYPETYPE
CLCL CONTROLCONTROL USERUSER
CLCL CONTROLCONTROL XML SCHEMA COLLECTIONXML SCHEMA COLLECTION
COCO CONNECTCONNECT DATABASEDATABASE
COCO CONNECTCONNECT ENDPOINTENDPOINT
CORPCORP CONNECT REPLICATIONCONNECT REPLICATION DATABASEDATABASE
COSQCOSQ CONNECT SQLCONNECT SQL SERVERSERVER
CPCP CHECKPOINTCHECKPOINT DATABASEDATABASE
CRACCRAC CREATE AVAILABILITY GROUPCREATE AVAILABILITY GROUP
적용 대상: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 through current version).
SERVERSERVER
CRAGCRAG CREATE AGGREGATECREATE AGGREGATE DATABASEDATABASE
CRAKCRAK CREATE ASYMMETRIC KEYCREATE ASYMMETRIC KEY DATABASEDATABASE
CRASCRAS CREATE ASSEMBLYCREATE ASSEMBLY DATABASEDATABASE
CRCFCRCF CREATE CERTIFICATECREATE CERTIFICATE DATABASEDATABASE
CRDBCRDB CREATE ANY DATABASECREATE ANY DATABASE SERVERSERVER
CRDBCRDB CREATE DATABASECREATE DATABASE DATABASEDATABASE
CRDECRDE CREATE DDL EVENT NOTIFICATIONCREATE DDL EVENT NOTIFICATION SERVERSERVER
CRDFCRDF CREATE DEFAULTCREATE DEFAULT DATABASEDATABASE
CREDCRED CREATE DATABASE DDL EVENT NOTIFICATIONCREATE DATABASE DDL EVENT NOTIFICATION DATABASEDATABASE
CRFNCRFN CREATE FUNCTIONCREATE FUNCTION DATABASEDATABASE
CRFTCRFT CREATE FULLTEXT CATALOGCREATE FULLTEXT CATALOG DATABASEDATABASE
CRHECRHE CREATE ENDPOINTCREATE ENDPOINT SERVERSERVER
CRMTCRMT CREATE MESSAGE TYPECREATE MESSAGE TYPE DATABASEDATABASE
CRPRCRPR CREATE PROCEDURECREATE PROCEDURE DATABASEDATABASE
CRQUCRQU CREATE QUEUECREATE QUEUE DATABASEDATABASE
CRRLCRRL CREATE ROLECREATE ROLE DATABASEDATABASE
CRRTCRRT CREATE ROUTECREATE ROUTE DATABASEDATABASE
CRRUCRRU CREATE RULECREATE RULE DATABASEDATABASE
CRSBCRSB CREATE REMOTE SERVICE BINDINGCREATE REMOTE SERVICE BINDING DATABASEDATABASE
CRSCCRSC CREATE CONTRACTCREATE CONTRACT DATABASEDATABASE
CRSKCRSK CREATE SYMMETRIC KEYCREATE SYMMETRIC KEY DATABASEDATABASE
CRSMCRSM CREATE SCHEMACREATE SCHEMA DATABASEDATABASE
CRSNCRSN CREATE SYNONYMCREATE SYNONYM DATABASEDATABASE
CRSOCRSO CREATE SEQUENCECREATE SEQUENCE SCHEMASCHEMA
CRSRCRSR CREATE SERVER ROLECREATE SERVER ROLE
적용 대상: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 through current version).
SERVERSERVER
CRSVCRSV CREATE SERVICECREATE SERVICE DATABASEDATABASE
CRTBCRTB CREATE TABLECREATE TABLE DATABASEDATABASE
CRTECRTE CREATE TRACE EVENT NOTIFICATIONCREATE TRACE EVENT NOTIFICATION SERVERSERVER
CRTYCRTY CREATE TYPECREATE TYPE DATABASEDATABASE
CRVWCRVW CREATE VIEWCREATE VIEW DATABASEDATABASE
CRXSCRXS CREATE XML SCHEMA COLLECTIONCREATE XML SCHEMA COLLECTION DATABASEDATABASE
DABODABO ADMINISTER DATABASE BULK OPERATIONSADMINISTER DATABASE BULK OPERATIONS
적용 대상: SQL 데이터베이스SQL Database.Applies to: SQL 데이터베이스SQL Database.
DATABASEDATABASE
DLDL DELETEDELETE DATABASEDATABASE
DLDL DELETEDELETE OBJECTOBJECT
DLDL DELETEDELETE SCHEMASCHEMA
EAESEAES EXECUTE ANY EXTERNAL SCRIPTEXECUTE ANY EXTERNAL SCRIPT
적용 대상: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 through current version).
DATABASEDATABASE
EXEX CREATE 문을 실행하기 전에EXECUTE DATABASEDATABASE
EXEX CREATE 문을 실행하기 전에EXECUTE OBJECTOBJECT
EXEX CREATE 문을 실행하기 전에EXECUTE SCHEMASCHEMA
EXEX CREATE 문을 실행하기 전에EXECUTE TYPETYPE
EXEX CREATE 문을 실행하기 전에EXECUTE XML SCHEMA COLLECTIONXML SCHEMA COLLECTION
IALIAL IMPERSONATE ANY LOGINIMPERSONATE ANY LOGIN
적용 대상: SQL ServerSQL Server ( SQL Server 2014SQL Server 2014 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2014SQL Server 2014 through current version).
SERVERSERVER
IMIM IMPERSONATEIMPERSONATE LoginLOGIN
IMIM IMPERSONATEIMPERSONATE USERUSER
ININ INSERTINSERT DATABASEDATABASE
ININ INSERTINSERT OBJECTOBJECT
ININ INSERTINSERT SCHEMASCHEMA
KIDCKIDC KILL DATABASE CONNECTIONKILL DATABASE CONNECTION
적용 대상: Azure SQL 데이터베이스Azure SQL Database.Applies to: Azure SQL 데이터베이스Azure SQL Database.
DATABASEDATABASE
RCRC RECEIVERECEIVE OBJECTOBJECT
RFRF REFERENCESREFERENCES ASSEMBLYASSEMBLY
RFRF REFERENCESREFERENCES ASYMMETRIC KEYASYMMETRIC KEY
RFRF REFERENCESREFERENCES CERTIFICATECERTIFICATE
RFRF REFERENCESREFERENCES CONTRACTCONTRACT
RFRF REFERENCESREFERENCES DATABASEDATABASE
RFRF REFERENCESREFERENCES
적용 대상: SQL Server 2017SQL Server 2017SQL 데이터베이스SQL Database합니다.Applies to: SQL Server 2017SQL Server 2017 and SQL 데이터베이스SQL Database.
DATABASE SCOPED CREDENTIALDATABASE SCOPED CREDENTIAL
RFRF REFERENCESREFERENCES FULLTEXT CATALOGFULLTEXT CATALOG
RFRF REFERENCESREFERENCES FULLTEXT STOPLISTFULLTEXT STOPLIST
RFRF REFERENCESREFERENCES SEARCH PROPERTY LISTSEARCH PROPERTY LIST
RFRF REFERENCESREFERENCES MESSAGE TYPEMESSAGE TYPE
RFRF REFERENCESREFERENCES OBJECTOBJECT
RFRF REFERENCESREFERENCES SCHEMASCHEMA
RFRF REFERENCESREFERENCES SYMMETRIC KEYSYMMETRIC KEY
RFRF REFERENCESREFERENCES TYPETYPE
RFRF REFERENCESREFERENCES XML SCHEMA COLLECTIONXML SCHEMA COLLECTION
SHDNSHDN SHUTDOWNSHUTDOWN SERVERSERVER
SLSL SELECTSELECT DATABASEDATABASE
SLSL SELECTSELECT OBJECTOBJECT
SLSL SELECTSELECT SCHEMASCHEMA
SNSN SENDSEND SERVICESERVICE
SPLNSPLN SHOWPLANSHOWPLAN DATABASEDATABASE
SUQNSUQN SUBSCRIBE QUERY NOTIFICATIONSSUBSCRIBE QUERY NOTIFICATIONS DATABASEDATABASE
SUSSUS SELECT ALL USER SECURABLESSELECT ALL USER SECURABLES
적용 대상: SQL ServerSQL Server ( SQL Server 2014SQL Server 2014 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2014SQL Server 2014 through current version).
SERVERSERVER
TOTO TAKE OWNERSHIPTAKE OWNERSHIP ASSEMBLYASSEMBLY
TOTO TAKE OWNERSHIPTAKE OWNERSHIP ASYMMETRIC KEYASYMMETRIC KEY
TOTO TAKE OWNERSHIPTAKE OWNERSHIP
적용 대상: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 through current version).
AVAILABILITY GROUPAVAILABILITY GROUP
TOTO TAKE OWNERSHIPTAKE OWNERSHIP CERTIFICATECERTIFICATE
TOTO TAKE OWNERSHIPTAKE OWNERSHIP CONTRACTCONTRACT
TOTO TAKE OWNERSHIPTAKE OWNERSHIP DATABASEDATABASE
TOTO TAKE OWNERSHIPTAKE OWNERSHIP
적용 대상: SQL Server 2017SQL Server 2017SQL 데이터베이스SQL Database합니다.Applies to: SQL Server 2017SQL Server 2017 and SQL 데이터베이스SQL Database.
DATABASE SCOPED CREDENTIALDATABASE SCOPED CREDENTIAL
TOTO TAKE OWNERSHIPTAKE OWNERSHIP ENDPOINTENDPOINT
TOTO TAKE OWNERSHIPTAKE OWNERSHIP FULLTEXT CATALOGFULLTEXT CATALOG
TOTO TAKE OWNERSHIPTAKE OWNERSHIP FULLTEXT STOPLISTFULLTEXT STOPLIST
TOTO TAKE OWNERSHIPTAKE OWNERSHIP SEARCH PROPERTY LISTSEARCH PROPERTY LIST
TOTO TAKE OWNERSHIPTAKE OWNERSHIP MESSAGE TYPEMESSAGE TYPE
TOTO TAKE OWNERSHIPTAKE OWNERSHIP OBJECTOBJECT
TOTO TAKE OWNERSHIPTAKE OWNERSHIP REMOTE SERVICE BINDINGREMOTE SERVICE BINDING
TOTO TAKE OWNERSHIPTAKE OWNERSHIP ROLEROLE
TOTO TAKE OWNERSHIPTAKE OWNERSHIP ROUTEROUTE
TOTO TAKE OWNERSHIPTAKE OWNERSHIP SCHEMASCHEMA
TOTO TAKE OWNERSHIPTAKE OWNERSHIP
적용 대상: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 through current version).
SERVER ROLESERVER ROLE
TOTO TAKE OWNERSHIPTAKE OWNERSHIP SERVICESERVICE
TOTO TAKE OWNERSHIPTAKE OWNERSHIP SYMMETRIC KEYSYMMETRIC KEY
TOTO TAKE OWNERSHIPTAKE OWNERSHIP TYPETYPE
TOTO TAKE OWNERSHIPTAKE OWNERSHIP XML SCHEMA COLLECTIONXML SCHEMA COLLECTION
UMSKUMSK UNMASKUNMASK
적용 대상: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 through current version).
DATABASEDATABASE
UPUP UPDATEUPDATE DATABASEDATABASE
UPUP UPDATEUPDATE OBJECTOBJECT
UPUP UPDATEUPDATE SCHEMASCHEMA
VWVW VIEW DEFINITIONVIEW DEFINITION APPLICATION ROLEAPPLICATION ROLE
VWVW VIEW DEFINITIONVIEW DEFINITION ASSEMBLYASSEMBLY
VWVW VIEW DEFINITIONVIEW DEFINITION ASYMMETRIC KEYASYMMETRIC KEY
VWVW VIEW DEFINITIONVIEW DEFINITION
적용 대상: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 through current version).
AVAILABILITY GROUPAVAILABILITY GROUP
VWVW VIEW DEFINITIONVIEW DEFINITION CERTIFICATECERTIFICATE
VWVW VIEW DEFINITIONVIEW DEFINITION CONTRACTCONTRACT
VWVW VIEW DEFINITIONVIEW DEFINITION DATABASEDATABASE
VWVW VIEW DEFINITIONVIEW DEFINITION
적용 대상: SQL Server 2017SQL Server 2017SQL 데이터베이스SQL Database합니다.Applies to: SQL Server 2017SQL Server 2017 and SQL 데이터베이스SQL Database.
DATABASE SCOPED CREDENTIALDATABASE SCOPED CREDENTIAL
VWVW VIEW DEFINITIONVIEW DEFINITION ENDPOINTENDPOINT
VWVW VIEW DEFINITIONVIEW DEFINITION FULLTEXT CATALOGFULLTEXT CATALOG
VWVW VIEW DEFINITIONVIEW DEFINITION FULLTEXT STOPLISTFULLTEXT STOPLIST
VWVW VIEW DEFINITIONVIEW DEFINITION LoginLOGIN
VWVW VIEW DEFINITIONVIEW DEFINITION MESSAGE TYPEMESSAGE TYPE
VWVW VIEW DEFINITIONVIEW DEFINITION OBJECTOBJECT
VWVW VIEW DEFINITIONVIEW DEFINITION REMOTE SERVICE BINDINGREMOTE SERVICE BINDING
VWVW VIEW DEFINITIONVIEW DEFINITION ROLEROLE
VWVW VIEW DEFINITIONVIEW DEFINITION ROUTEROUTE
VWVW VIEW DEFINITIONVIEW DEFINITION SCHEMASCHEMA
VWVW VIEW DEFINITIONVIEW DEFINITION SEARCH PROPERTY LISTSEARCH PROPERTY LIST
VWVW VIEW DEFINITIONVIEW DEFINITION
적용 대상: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2012SQL Server 2012 through current version).
SERVER ROLESERVER ROLE
VWVW VIEW DEFINITIONVIEW DEFINITION SERVICESERVICE
VWVW VIEW DEFINITIONVIEW DEFINITION SYMMETRIC KEYSYMMETRIC KEY
VWVW VIEW DEFINITIONVIEW DEFINITION TYPETYPE
VWVW VIEW DEFINITIONVIEW DEFINITION USERUSER
VWVW VIEW DEFINITIONVIEW DEFINITION XML SCHEMA COLLECTIONXML SCHEMA COLLECTION
VWADVWAD VIEW ANY DEFINITIONVIEW ANY DEFINITION SERVERSERVER
VWCKVWCK VIEW ANY COLUMN ENCRYPTION KEY DEFINITIONVIEW ANY COLUMN ENCRYPTION KEY DEFINITION
적용 대상: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 through current version).
DATABASEDATABASE
VWCMVWCM VIEW ANY COLUMN MASTER KEY DEFINITIONVIEW ANY COLUMN MASTER KEY DEFINITION
적용 대상: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 ~ 현재 버전).Applies to: SQL ServerSQL Server ( SQL Server 2016SQL Server 2016 through current version).
DATABASEDATABASE
VWCTVWCT VIEW CHANGE TRACKINGVIEW CHANGE TRACKING OBJECTOBJECT
VWCTVWCT VIEW CHANGE TRACKINGVIEW CHANGE TRACKING SCHEMASCHEMA
VWDBVWDB VIEW ANY DATABASEVIEW ANY DATABASE SERVERSERVER
VWDSVWDS VIEW DATABASE STATEVIEW DATABASE STATE DATABASEDATABASE
VWSSVWSS VIEW SERVER STATEVIEW SERVER STATE SERVERSERVER
XAXA EXTERNAL ACCESS ASSEMBLYEXTERNAL ACCESS ASSEMBLY SERVERSERVER
XUXU UNSAFE ASSEMBLYUNSAFE ASSEMBLY SERVERSERVER

주의Remarks

sys.fn_builtin_permissions는 미리 정의된 사용 권한 계층의 복사본을 생성하는 테이블 반환 함수입니다.sys.fn_builtin_permissions is a table-valued function that emits a copy of the predefined permission hierarchy. 이 계층에는 적용되는 모든 사용 권한이 포함됩니다.This hierarchy includes covering permissions. DEFAULT 는 루트는 사용 권한 계층에 대 한 비순환 그래프를 설명 하는 결과 집합 (클래스 = SERVER, 사용 권한 = CONTROL SERVER).The DEFAULT result set describes a directed, acyclic graph of the permissions hierarchy, of which the root is (class = SERVER, permission = CONTROL SERVER).

sys.fn_builtin_permissions는 상호 관련된 매개 변수를 허용하지 않습니다.sys.fn_builtin_permissions does not accept correlated parameters.

유효하지 않은 클래스 이름으로 sys.fn_builtin_permissions를 호출하면 빈 집합이 반환됩니다.sys.fn_builtin_permissions will return an empty set when it is called with a class name that is not valid.

다음 그래픽에서는 권한과 각 권한의 상호 관계를 보여 줍니다.The following graphic shows the permissions and their relationships to each other. 일부 높은 수준의 권한(예: CONTROL SERVER)은 여러 번 나열되어 있습니다.Some of the higher level permissions (such as CONTROL SERVER) are listed many times.

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

참고

이 항목에 포함된 포스터가 너무 작아 읽기 어렵습니다.As part of this topic the poster is far to small to read. http://go.microsoft.com/fwlink/?LinkId=229142에서 데이터베이스 엔진 권한 포스터를 다운로드하세요.Download the Database Engine Permissions Poster from http://go.microsoft.com/fwlink/?LinkId=229142.

PermissionsPermissions

public 역할의 멤버 자격이 필요합니다.Requires membership in the public role.

Examples

1.A. 모든 기본 제공 사용 권한 나열Listing all built in permissions

사용 하 여 DEFAULT 또는 모든 사용 권한을 반환 하는 빈 문자열입니다.Use DEFAULT or an empty string to return all permissions.

SELECT * FROM sys.fn_builtin_permissions(DEFAULT);
SELECT * FROM sys.fn_builtin_permissions('');  

2.B. 대칭 키에 설정할 수 있는 사용 권한 나열Listing permissions that can be set on a symmetric key

해당 클래스에 대 한 모든 가능한 사용 권한을 반환 하는 클래스를 지정 합니다.Specify a class to return all possible permissions for that class.

SELECT * FROM sys.fn_builtin_permissions(N'SYMMETRIC KEY');  

3.C. SELECT 사용 권한이 있는 클래스 나열Listing classes on which there is a SELECT permission

SELECT * FROM sys.fn_builtin_permissions(DEFAULT)   
    WHERE permission_name = 'SELECT';  

관련 항목:See Also

사용 권한 계층(데이터베이스 엔진) Permissions Hierarchy (Database Engine)
GRANT(Transact-SQL) GRANT (Transact-SQL)
스키마 ( 만들기 Transact SQL ) CREATE SCHEMA (Transact-SQL)
DROP 스키마 ( Transact SQL ) DROP SCHEMA (Transact-SQL)
사용 권한(데이터베이스 엔진) Permissions (Database Engine)
sys.fn_my_permissions ( Transact SQL ) sys.fn_my_permissions (Transact-SQL)
HAS_PERMS_BY_NAME(Transact-SQL)HAS_PERMS_BY_NAME (Transact-SQL)