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

S’applique à :Applies to: ouiSQL ServerSQL Server (toutes les versions prises en charge) yesSQL ServerSQL Server (all supported versions) OuiAzure SQL DatabaseAzure SQL DatabaseYesAzure SQL DatabaseAzure SQL DatabaseS’applique à :Applies to: ouiSQL ServerSQL Server (toutes les versions prises en charge) yesSQL ServerSQL Server (all supported versions) OuiAzure SQL DatabaseAzure SQL DatabaseYesAzure SQL DatabaseAzure SQL Database

Retourne une description de la hiérarchie des autorisations intégrées du serveur.Returns a description of the built in permissions hierarchy of the server. sys.fn_builtin_permissionspeut uniquement être appelé sur SQL ServerSQL Server et Azure SQL DatabaseAzure SQL Database , et retourne toutes les autorisations, qu’elles soient prises en charge ou non sur la plateforme actuelle.sys.fn_builtin_permissions can only be called on SQL ServerSQL Server and Azure SQL DatabaseAzure SQL Database, and it returns all permissions regardless of whether they are supported on the current platform. La plupart des autorisations s’appliquent à toutes les plates-formes, mais ce n’est pas le cas pour certaines d’entre elles.Most permissions apply to all platforms, but some do not. Par exemple, les autorisations de niveau serveur ne peuvent pas être accordées sur SQL Database.For example server level permissions cannot be granted on SQL Database. Pour plus d’informations sur les plateformes qui prennent en charge chaque autorisation, consultez autorisations (Moteur de base de données).For information about which platforms support each permission, see Permissions (Database Engine).

Icône du lien de rubrique Conventions de la syntaxe Transact-SQLTopic link icon Transact-SQL Syntax Conventions

SyntaxeSyntax

  
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  

ArgumentsArguments

DEFAULTDEFAULT
Quand elle est appelée avec l’option par défaut (sans guillemets), la fonction retourne la liste complète des autorisations intégrées.When it is called with the DEFAULT option (without quotes), the function will return a complete list of built in permissions.

NULLNULL
Équivalent à DEFAULT.Equivalent to DEFAULT.

empty_stringempty_string
Équivalent à DEFAULT.Equivalent to DEFAULT.

'<securable_class>''<securable_class>'
Lorsqu’il est appelé avec le nom d’une classe sécurisable, sys. fn_builtin_permissions retourne toutes les autorisations qui s’appliquent à la classe.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> est un littéral de chaîne qui requiert des guillemets.<securable_class> is a string literal that requires quotation marks. nvarchar(60)nvarchar(60)

Tables retournéesTables Returned

Nom de la colonneColumn name Type de donnéesData type ClassementCollation DescriptionDescription
class_descclass_desc nvarchar(60)nvarchar(60) Classement du serveur.Collation of the server Description de la classe sécurisable.Description of the securable class.
permission_namepermission_name nvarchar(60)nvarchar(60) Classement du serveur.Collation of the server Nom de l’autorisation.Permission name.
typetype varchar(4)varchar(4) Classement du serveur.Collation of the server Code du type d'autorisation compacte.Compact permission type code. Consultez le tableau qui suit.See the table that follows.
covering_permission_namecovering_permission_name nvarchar(60)nvarchar(60) Classement du serveur.Collation of the server S'il n'est pas NULL, il s'agit du nom de l'autorisation de cette classe, qui implique les autres autorisations de la classe.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) Classement du serveur.Collation of the server S'il n'est pas NULL, il s'agit du nom de la classe parente qui contient la classe actuelle.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) Classement du serveur.Collation of the server S'il n'est pas NULL, il s'agit du nom de l'autorisation de la classe parente, qui implique toutes les autres autorisations de cette classe.If not NULL, this is the name of the permission on the parent class that implies all other permissions on that class.

Types d’autorisationsPermission Types

Type d'autorisationPermission type Nom de l'autorisationPermission name S'applique à un élément sécurisable ou une classeApplies to securable or class
AADSAADS ALTER ANY DATABASE EVENT SESSIONALTER ANY DATABASE EVENT SESSION
S’applique à: SQL ServerSQL Server ( SQL Server 2014 (12.x)SQL Server 2014 (12.x) jusqu’à la version actuelle).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
S’applique à: SQL ServerSQL Server ( SQL Server 2016 (13.x)SQL Server 2016 (13.x) jusqu’à la version actuelle).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
S’applique à: SQL ServerSQL Server ( SQL Server 2016 (13.x)SQL Server 2016 (13.x) jusqu’à la version actuelle).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
S’applique à: SQL ServerSQL Server ( SQL Server 2016 (13.x)SQL Server 2016 (13.x) jusqu’à la version actuelle).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
S’applique à: SQL ServerSQL Server ( SQL Server 2012 (11.x)SQL Server 2012 (11.x) jusqu’à la version actuelle).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
Applique t o: SQL Server 2017 (14.x)SQL Server 2017 (14.x) et SQL DatabaseSQL Database .Applies t o: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and SQL DatabaseSQL Database.
DATABASE SCOPED CREDENTIALDATABASE SCOPED CREDENTIAL
ALAL ALTERALTER ENDPOINTENDPOINT
ALAL ALTERALTER FULLTEXT CATALOGFULLTEXT CATALOG
ALAL ALTERALTER FULLTEXT STOPLISTFULLTEXT STOPLIST
ALAL ALTERALTER ConnexionLOGIN
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
S’applique à: SQL ServerSQL Server ( SQL Server 2012 (11.x)SQL Server 2012 (11.x) jusqu’à la version actuelle).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 UtilisateurUSER
ALAL ALTERALTER XML SCHEMA COLLECTIONXML SCHEMA COLLECTION
ALAAALAA ALTER ANY SERVER AUDITALTER ANY SERVER AUDIT SERVERSERVER
ALAGALAG ALTER ANY AVAILABILITY GROUPALTER ANY AVAILABILITY GROUP
S’applique à: SQL ServerSQL Server ( SQL Server 2012 (11.x)SQL Server 2012 (11.x) jusqu’à la version actuelle).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
S’applique à: SQL ServerSQL Server ( SQL Server 2016 (13.x)SQL Server 2016 (13.x) jusqu’à la version actuelle).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
S’applique à: SQL ServerSQL Server ( SQL Server 2016 (13.x)SQL Server 2016 (13.x) jusqu’à la version actuelle).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
S’applique à: SQL ServerSQL Server ( SQL Server 2016 (13.x)SQL Server 2016 (13.x) jusqu’à la version actuelle).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 MODIFIER UNE STRATÉGIE DE SÉCURITÉALTER ANY SECURITY POLICY
S’applique à: SQL ServerSQL Server ( SQL Server 2016 (13.x)SQL Server 2016 (13.x) jusqu’à la version actuelle).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
S’applique à: SQL ServerSQL Server ( SQL Server 2012 (11.x)SQL Server 2012 (11.x) jusqu’à la version actuelle).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
S’applique à: SQL ServerSQL Server ( SQL Server 2014 (12.x)SQL Server 2014 (12.x) jusqu’à la version actuelle).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
S’applique à: SQL ServerSQL Server ( SQL Server 2012 (11.x)SQL Server 2012 (11.x) jusqu’à la version actuelle).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
S’applique à  : SQL Server 2017 (14.x)SQL Server 2017 (14.x) et SQL DatabaseSQL Database.Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and SQL DatabaseSQL Database.
DATABASE SCOPED CREDENTIALDATABASE SCOPED CREDENTIAL
CLCL CONTROLCONTROL ENDPOINTENDPOINT
CLCL CONTROLCONTROL FULLTEXT CATALOGFULLTEXT CATALOG
CLCL CONTROLCONTROL FULLTEXT STOPLISTFULLTEXT STOPLIST
CLCL CONTROLCONTROL ConnexionLOGIN
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
S’applique à: SQL ServerSQL Server ( SQL Server 2012 (11.x)SQL Server 2012 (11.x) jusqu’à la version actuelle).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 TYPETYPE
CLCL CONTROLCONTROL UtilisateurUSER
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 Créer un groupe de disponibilitéCREATE AVAILABILITY GROUP
S’applique à: SQL ServerSQL Server ( SQL Server 2012 (11.x)SQL Server 2012 (11.x) jusqu’à la version actuelle).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
S’applique à: SQL ServerSQL Server ( SQL Server 2012 (11.x)SQL Server 2012 (11.x) jusqu’à la version actuelle).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
S'applique à: SQL DatabaseSQL Database.Applies to: SQL DatabaseSQL Database.
DATABASEDATABASE
DLDL SuppressionDELETE DATABASEDATABASE
DLDL SuppressionDELETE OBJECTOBJECT
DLDL SuppressionDELETE SCHEMASCHEMA
EAESEAES EXECUTE ANY EXTERNAL SCRIPTEXECUTE ANY EXTERNAL SCRIPT
S’applique à: SQL ServerSQL Server ( SQL Server 2016 (13.x)SQL Server 2016 (13.x) jusqu’à la version actuelle).Applies to: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) through current version).
DATABASEDATABASE
EXEX ExécutezEXECUTE DATABASEDATABASE
EXEX ExécutezEXECUTE OBJECTOBJECT
EXEX ExécutezEXECUTE SCHEMASCHEMA
EXEX ExécutezEXECUTE TYPETYPE
EXEX ExécutezEXECUTE XML SCHEMA COLLECTIONXML SCHEMA COLLECTION
IALIAL IMPERSONATE ANY LOGINIMPERSONATE ANY LOGIN
S’applique à: SQL ServerSQL Server ( SQL Server 2014 (12.x)SQL Server 2014 (12.x) jusqu’à la version actuelle).Applies to: SQL ServerSQL Server (SQL Server 2014 (12.x)SQL Server 2014 (12.x) through current version).
SERVERSERVER
IMIM IMPERSONATEIMPERSONATE ConnexionLOGIN
IMIM IMPERSONATEIMPERSONATE UtilisateurUSER
ININ INSERTINSERT DATABASEDATABASE
ININ INSERTINSERT OBJECTOBJECT
ININ INSERTINSERT SCHEMASCHEMA
KIDCKIDC KILL DATABASE CONNECTIONKILL DATABASE CONNECTION
S'applique à: Azure SQL DatabaseAzure SQL Database.Applies to: Azure SQL DatabaseAzure SQL Database.
DATABASEDATABASE
RCRC RECEIVERECEIVE OBJECTOBJECT
RFRF RÉFÉRENCESREFERENCES ASSEMBLYASSEMBLY
RFRF RÉFÉRENCESREFERENCES ASYMMETRIC KEYASYMMETRIC KEY
RFRF RÉFÉRENCESREFERENCES CERTIFICATECERTIFICATE
RFRF RÉFÉRENCESREFERENCES CONTRACTCONTRACT
RFRF RÉFÉRENCESREFERENCES DATABASEDATABASE
RFRF RÉFÉRENCESREFERENCES
S’applique à  : SQL Server 2017 (14.x)SQL Server 2017 (14.x) et SQL DatabaseSQL Database.Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and SQL DatabaseSQL Database.
DATABASE SCOPED CREDENTIALDATABASE SCOPED CREDENTIAL
RFRF RÉFÉRENCESREFERENCES FULLTEXT CATALOGFULLTEXT CATALOG
RFRF RÉFÉRENCESREFERENCES FULLTEXT STOPLISTFULLTEXT STOPLIST
RFRF RÉFÉRENCESREFERENCES SEARCH PROPERTY LISTSEARCH PROPERTY LIST
RFRF RÉFÉRENCESREFERENCES MESSAGE TYPEMESSAGE TYPE
RFRF RÉFÉRENCESREFERENCES OBJECTOBJECT
RFRF RÉFÉRENCESREFERENCES SCHEMASCHEMA
RFRF RÉFÉRENCESREFERENCES SYMMETRIC KEYSYMMETRIC KEY
RFRF RÉFÉRENCESREFERENCES TYPETYPE
RFRF RÉFÉRENCESREFERENCES 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
S’applique à: SQL ServerSQL Server ( SQL Server 2014 (12.x)SQL Server 2014 (12.x) jusqu’à la version actuelle).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
S’applique à: SQL ServerSQL Server ( SQL Server 2012 (11.x)SQL Server 2012 (11.x) jusqu’à la version actuelle).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
S’applique à  : SQL Server 2017 (14.x)SQL Server 2017 (14.x) et SQL DatabaseSQL Database.Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and SQL DatabaseSQL 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
S’applique à: SQL ServerSQL Server ( SQL Server 2012 (11.x)SQL Server 2012 (11.x) jusqu’à la version actuelle).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 TYPETYPE
TOTO TAKE OWNERSHIPTAKE OWNERSHIP XML SCHEMA COLLECTIONXML SCHEMA COLLECTION
UMSKUMSK UNMASKUNMASK
S’applique à: SQL ServerSQL Server ( SQL Server 2016 (13.x)SQL Server 2016 (13.x) jusqu’à la version actuelle).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
S’applique à: SQL ServerSQL Server ( SQL Server 2012 (11.x)SQL Server 2012 (11.x) jusqu’à la version actuelle).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
S’applique à  : SQL Server 2017 (14.x)SQL Server 2017 (14.x) et SQL DatabaseSQL Database.Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and SQL DatabaseSQL 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 ConnexionLOGIN
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
S’applique à: SQL ServerSQL Server ( SQL Server 2012 (11.x)SQL Server 2012 (11.x) jusqu’à la version actuelle).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 TYPETYPE
VWVW VIEW DEFINITIONVIEW DEFINITION UtilisateurUSER
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
S’applique à: SQL ServerSQL Server ( SQL Server 2016 (13.x)SQL Server 2016 (13.x) jusqu’à la version actuelle).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
S’applique à: SQL ServerSQL Server ( SQL Server 2016 (13.x)SQL Server 2016 (13.x) jusqu’à la version actuelle).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

RemarquesRemarks

sys.fn_builtin_permissions est une fonction table qui émet une copie de la hiérarchie d'autorisations prédéfinies.sys.fn_builtin_permissions is a table-valued function that emits a copy of the predefined permission hierarchy. Cette hiérarchie inclut les autorisations d'accompagnement.This hierarchy includes covering permissions. Le DEFAULT jeu de résultats décrit un graphique cyclique et orienté de la hiérarchie des autorisations, dont la racine est (Class = Server, permission = 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 n'accepte pas de paramètres mis en corrélation.sys.fn_builtin_permissions does not accept correlated parameters.

sys.fn_builtin_permissions retournera un jeu vide s'il est appelé avec un nom de classe qui n'est pas valide.sys.fn_builtin_permissions will return an empty set when it is called with a class name that is not valid.

Le graphique suivant illustre les autorisations et leurs relations.The following graphic shows the permissions and their relationships to each other. Certaines des autorisations de niveau supérieur (telles que CONTROL SERVER) figurent plusieurs fois.Some of the higher level permissions (such as CONTROL SERVER) are listed many times. Dans cet article, l’affiche est trop petite pour être lue correctement.In this article, the poster is far too small to read. Cliquez sur l’image pour télécharger le Poster des autorisations du moteur de base de données au format pdf.Click the image to download the Database Engine Permissions Poster in pdf format.

Autorisations des moteurs de base de donnéesDatabase Engine Permissions

AutorisationsPermissions

Nécessite l'appartenance au rôle public.Requires membership in the public role.

ExemplesExamples

R.A. Liste de toutes les autorisations intégréesListing all built in permissions

Utilisez DEFAULT ou une chaîne vide pour retourner toutes les autorisations.Use DEFAULT or an empty string to return all permissions.

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

B.B. Liste des autorisations qui peuvent être définies sur une clé symétriqueListing permissions that can be set on a symmetric key

Spécifiez une classe pour retourner toutes les autorisations possibles pour cette classe.Specify a class to return all possible permissions for that class.

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

C.C. Liste des classes sur lesquelles il existe une autorisation SELECTListing classes on which there is a SELECT permission

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

Voir aussiSee Also

Hiérarchie des autorisations (Moteur de base de données) Permissions Hierarchy (Database Engine)
GRANT ()Transact-SQL GRANT (Transact-SQL)
CRÉER un schéma ()Transact-SQL CREATE SCHEMA (Transact-SQL)
DROP SCHEMA (Transact-SQL) DROP SCHEMA (Transact-SQL)
Autorisations (Moteur de base de données) 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)