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

适用对象:是SQL Server 是Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库 APPLIES TO: yesSQL Server yesAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

返回服务器内置权限层次结构的说明。Returns a description of the built in permissions hierarchy of the server. sys.fn_builtin_permissions只能在和SQL ServerSQL Server Azure 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>'
当使用一个安全对象类的名称调用时,fn_builtin_permissions sys.databases 会返回应用于该类的所有权限。When it is called with the name of one securable class, sys.fn_builtin_permissions will return all permissions that apply to the class. <securable_class> 是需要用引号引起来的字符串文字。<securable_class> is a string literal that requires quotation marks. nvarchar (60)nvarchar(60)

返回的表Tables Returned

列名称Column name 数据类型Data type 排序规则Collation 说明Description
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.
typetype 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 ServerSQL Server 2014 (12.x)SQL Server 2014 (12.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2014 (12.x)SQL Server 2014 (12.x) through current version).
DATABASEDATABASE
AAESAAES ALTER ANY EVENT SESSIONALTER ANY EVENT SESSION SERVERSERVER
AAMKAAMK ALTER ANY MASKALTER ANY MASK
适用范围SQL ServerSQL ServerSQL Server 2016 (13.x)SQL Server 2016 (13.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) through current version).
DATABASEDATABASE
ADBOADBO ADMINISTER BULK OPERATIONSADMINISTER BULK OPERATIONS SERVERSERVER
AEDSAEDS ALTER ANY EXTERNAL DATA SOURCEALTER ANY EXTERNAL DATA SOURCE
适用范围SQL ServerSQL ServerSQL Server 2016 (13.x)SQL Server 2016 (13.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) through current version).
DATABASEDATABASE
AEFFAEFF ALTER ANY EXTERNAL FILE FORMATALTER ANY EXTERNAL FILE FORMAT
适用范围SQL ServerSQL ServerSQL Server 2016 (13.x)SQL Server 2016 (13.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) through current version).
DATABASEDATABASE
ALAL ALTERALTER APPLICATION ROLEAPPLICATION ROLE
ALAL ALTERALTER ASSEMBLYASSEMBLY
ALAL ALTERALTER
适用范围SQL ServerSQL ServerSQL Server 2012 (11.x)SQL Server 2012 (11.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) through current version).
AVAILABILITY GROUPAVAILABILITY GROUP
ALAL ALTERALTER ASYMMETRIC KEYASYMMETRIC KEY
ALAL ALTERALTER CERTIFICATECERTIFICATE
ALAL ALTERALTER CONTRACTCONTRACT
ALAL ALTERALTER DATABASEDATABASE
ALAL ALTERALTER
应用 t oSQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL 数据库SQL DatabaseApplies t o: SQL Server 2017 (14.x)SQL Server 2017 (14.x) 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 ServerSQL Server 2012 (11.x)SQL Server 2012 (11.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) 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 ServerSQL Server 2012 (11.x)SQL Server 2012 (11.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) 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 ServerSQL Server 2016 (13.x)SQL Server 2016 (13.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) through current version).
DATABASEDATABASE
ALCMALCM ALTER ANY COLUMN MASTER KEYALTER ANY COLUMN MASTER KEY
适用范围SQL ServerSQL ServerSQL Server 2016 (13.x)SQL Server 2016 (13.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) 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 ServerSQL Server 2016 (13.x)SQL Server 2016 (13.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) 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 POLICY
适用范围SQL ServerSQL ServerSQL Server 2016 (13.x)SQL Server 2016 (13.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) through current version).
DATABASEDATABASE
ALSRALSR ALTER ANY SERVER ROLEALTER ANY SERVER ROLE
适用范围SQL ServerSQL ServerSQL Server 2012 (11.x)SQL Server 2012 (11.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) 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 ServerSQL Server 2014 (12.x)SQL Server 2014 (12.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2014 (12.x)SQL Server 2014 (12.x) through current version).
SERVERSERVER
CLCL CONTROLCONTROL APPLICATION ROLEAPPLICATION ROLE
CLCL CONTROLCONTROL ASSEMBLYASSEMBLY
CLCL CONTROLCONTROL ASYMMETRIC KEYASYMMETRIC KEY
CLCL CONTROLCONTROL
适用范围SQL ServerSQL ServerSQL Server 2012 (11.x)SQL Server 2012 (11.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) through current version).
AVAILABILITY GROUPAVAILABILITY GROUP
CLCL CONTROLCONTROL CERTIFICATECERTIFICATE
CLCL CONTROLCONTROL CONTRACTCONTRACT
CLCL CONTROLCONTROL DATABASEDATABASE
CLCL CONTROLCONTROL
适用于: SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL 数据库SQL DatabaseApplies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) 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 ServerSQL Server 2012 (11.x)SQL Server 2012 (11.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) through current version).
SERVER ROLESERVER ROLE
CLCL CONTROLCONTROL SERVICESERVICE
CLCL CONTROLCONTROL SYMMETRIC KEYSYMMETRIC KEY
CLCL CONTROLCONTROL 类型TYPE
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 ServerSQL Server 2012 (11.x)SQL Server 2012 (11.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) 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 ServerSQL Server 2012 (11.x)SQL Server 2012 (11.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) 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 DatabaseApplies to: SQL 数据库SQL Database.
DATABASEDATABASE
DLDL DELETEDELETE DATABASEDATABASE
DLDL DELETEDELETE OBJECTOBJECT
DLDL DELETEDELETE SCHEMASCHEMA
EAESEAES EXECUTE ANY EXTERNAL SCRIPTEXECUTE ANY EXTERNAL SCRIPT
适用范围SQL ServerSQL ServerSQL Server 2016 (13.x)SQL Server 2016 (13.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) through current version).
DATABASEDATABASE
EXEX 在运行 CREATE 语句前执行EXECUTE DATABASEDATABASE
EXEX 在运行 CREATE 语句前执行EXECUTE OBJECTOBJECT
EXEX 在运行 CREATE 语句前执行EXECUTE SCHEMASCHEMA
EXEX 在运行 CREATE 语句前执行EXECUTE 类型TYPE
EXEX 在运行 CREATE 语句前执行EXECUTE XML SCHEMA COLLECTIONXML SCHEMA COLLECTION
IALIAL IMPERSONATE ANY LOGINIMPERSONATE ANY LOGIN
适用范围SQL ServerSQL ServerSQL Server 2014 (12.x)SQL Server 2014 (12.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2014 (12.x)SQL Server 2014 (12.x) 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 DatabaseApplies 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 2017 (14.x)SQL Server 2017 (14.x)SQL 数据库SQL DatabaseApplies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) 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 类型TYPE
RFRF REFERENCESREFERENCES XML SCHEMA COLLECTIONXML SCHEMA COLLECTION
SHDNSHDN 关机SHUTDOWN 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 ServerSQL Server 2014 (12.x)SQL Server 2014 (12.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2014 (12.x)SQL Server 2014 (12.x) through current version).
SERVERSERVER
TOTO TAKE OWNERSHIPTAKE OWNERSHIP ASSEMBLYASSEMBLY
TOTO TAKE OWNERSHIPTAKE OWNERSHIP ASYMMETRIC KEYASYMMETRIC KEY
TOTO TAKE OWNERSHIPTAKE OWNERSHIP
适用范围SQL ServerSQL ServerSQL Server 2012 (11.x)SQL Server 2012 (11.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) 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 2017 (14.x)SQL Server 2017 (14.x)SQL 数据库SQL DatabaseApplies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) 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 ServerSQL Server 2012 (11.x)SQL Server 2012 (11.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) through current version).
SERVER ROLESERVER ROLE
TOTO TAKE OWNERSHIPTAKE OWNERSHIP SERVICESERVICE
TOTO TAKE OWNERSHIPTAKE OWNERSHIP SYMMETRIC KEYSYMMETRIC KEY
TOTO TAKE OWNERSHIPTAKE OWNERSHIP 类型TYPE
TOTO TAKE OWNERSHIPTAKE OWNERSHIP XML SCHEMA COLLECTIONXML SCHEMA COLLECTION
UMSKUMSK UNMASKUNMASK
适用范围SQL ServerSQL ServerSQL Server 2016 (13.x)SQL Server 2016 (13.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) 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 ServerSQL Server 2012 (11.x)SQL Server 2012 (11.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) 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 2017 (14.x)SQL Server 2017 (14.x)SQL 数据库SQL DatabaseApplies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) 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 ServerSQL Server 2012 (11.x)SQL Server 2012 (11.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) through current version).
SERVER ROLESERVER ROLE
VWVW VIEW DEFINITIONVIEW DEFINITION SERVICESERVICE
VWVW VIEW DEFINITIONVIEW DEFINITION SYMMETRIC KEYSYMMETRIC KEY
VWVW VIEW DEFINITIONVIEW DEFINITION 类型TYPE
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 ServerSQL Server 2016 (13.x)SQL Server 2016 (13.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) through current version).
DATABASEDATABASE
VWCMVWCM VIEW ANY COLUMN MASTER KEY DEFINITIONVIEW ANY COLUMN MASTER KEY DEFINITION
适用范围SQL ServerSQL ServerSQL Server 2016 (13.x)SQL Server 2016 (13.x)当前版本)。Applies to: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) 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`结果集描述了权限层次结构的有向非循环图形,其根为(CLASS = 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. [!INCLUDE[database-engine-permissions](../../includes/paragraph-content/database-engine-permissions.md)] ## 权限Permissions 要求具有 public 角色的成员身份。Requires membership in the public role. ## 示例Examples ### A.A. 列出所有内置权限Listing all built in permissions 使用`DEFAULT`或空字符串返回所有权限。Use `DEFAULT` or an empty string to return all permissions. ```sql SELECT * FROM sys.fn_builtin_permissions(DEFAULT); SELECT * FROM sys.fn_builtin_permissions(''); ``` ### B.B. 列出可针对对称密钥设置的权限Listing permissions that can be set on a symmetric key 指定类以返回该类的所有可能的权限。Specify a class to return all possible permissions for that class. ```sql SELECT * FROM sys.fn_builtin_permissions(N'SYMMETRIC KEY'); ``` ### C.C. 列出对其拥有 SELECT 权限的类Listing classes on which there is a SELECT permission ```sql SELECT * FROM sys.fn_builtin_permissions(DEFAULT) WHERE permission_name = 'SELECT'; ``` ## 另请参阅See Also [权限层次结构(数据库引擎)](../../relational-databases/security/permissions-hierarchy-database-engine.md) [Permissions Hierarchy (Database Engine)](../../relational-databases/security/permissions-hierarchy-database-engine.md) [GRANT (Transact-SQL)](../../t-sql/statements/grant-transact-sql.md) [GRANT (Transact-SQL)](../../t-sql/statements/grant-transact-sql.md) [CREATE SCHEMA (Transact-SQL)](../../t-sql/statements/create-schema-transact-sql.md) [CREATE SCHEMA (Transact-SQL)](../../t-sql/statements/create-schema-transact-sql.md) [DROP SCHEMA (Transact-SQL)](../../t-sql/statements/drop-schema-transact-sql.md) [DROP SCHEMA (Transact-SQL)](../../t-sql/statements/drop-schema-transact-sql.md) [权限 (数据库引擎)](../../relational-databases/security/permissions-database-engine.md) [Permissions (Database Engine)](../../relational-databases/security/permissions-database-engine.md) [sys. fn_my_permissions (Transact-sql)](../../relational-databases/system-functions/sys-fn-my-permissions-transact-sql.md) [sys.fn_my_permissions (Transact-SQL)](../../relational-databases/system-functions/sys-fn-my-permissions-transact-sql.md) [HAS_PERMS_BY_NAME (Transact-SQL)HAS_PERMS_BY_NAME (Transact-SQL)](../../t-sql/functions/has-perms-by-name-transact-sql.md)