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

SE APLICA A: síSQL Server (a partir de 2008) síAzure SQL Database noAzure SQL Data Warehouse noAlmacenamiento de datos paralelos APPLIES TO: yesSQL Server (starting with 2008) yesAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

Devuelve una descripción de la jerarquía de permisos integrados del servidor.Returns a description of the built in permissions hierarchy of the server. sys.fn_builtin_permissions solo se puede llamar en SQL ServerSQL Server y Base de datos SQL de AzureAzure SQL Database, y devuelve todos los permisos, independientemente de si son compatibles con la plataforma actual.sys.fn_builtin_permissions can only be called on SQL ServerSQL Server and Base de datos SQL de AzureAzure SQL Database, and it returns all permissions regardless of whether they are supported on the current platform. La mayoría de los permisos se aplica a todas las plataformas, pero otros no.Most permissions apply to all platforms, but some do not. Por ejemplo no se puede conceder permisos de nivel de servidor en la base de datos SQL.For example server level permissions cannot be granted on SQL Database. Para obtener información acerca de qué plataformas son compatibles con cada permiso, vea permisos (motor de base de datos).For information about which platforms support each permission, see Permissions (Database Engine).

Icono de vínculo de tema Convenciones de sintaxis de Transact-SQLTopic link icon Transact-SQL Syntax Conventions

SintaxisSyntax

  
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  

ArgumentosArguments

DEFAULTDEFAULT
Cuando se llama con la opción predeterminada (sin comillas), la función devolverá una lista completa de permisos integrados.When it is called with the DEFAULT option (without quotes), the function will return a complete list of built in permissions.

NULLNULL
Equivalente a DEFAULT.Equivalent to DEFAULT.

empty_stringempty_string
Equivalente a DEFAULT.Equivalent to DEFAULT.

'<securable_class>''<securable_class>'
Cuando se llama con el nombre de una clase protegible, sys.fn_builtin_permissions devolverá todos los permisos que se aplican a la clase.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 > es un literal de cadena que requiere comillas.<securable_class> is a string literal that requires quotation marks. nvarchar(60)nvarchar(60)

Tablas devueltasTables Returned

Nombre de columnaColumn name Tipo de datosData type IntercalaciónCollation DescripciónDescription
class_descclass_desc nvarchar(60)nvarchar(60) Intercalación del servidorCollation of the server Descripción de la clase protegible.Description of the securable class.
permission_namepermission_name nvarchar(60)nvarchar(60) Intercalación del servidorCollation of the server Nombre del permiso.Permission name.
Tipotype varchar(4)varchar(4) Intercalación del servidorCollation of the server Código de tipo de permiso compacto.Compact permission type code. Vea la tabla siguiente.See the table that follows.
covering_permission_namecovering_permission_name nvarchar(60)nvarchar(60) Intercalación del servidorCollation of the server Si no es NULL, es el nombre del permiso en esta clase que implica los otros permisos en la clase.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) Intercalación del servidorCollation of the server S no es NULL, es el nombre de la clase principal que contiene la clase actual.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) Intercalación del servidorCollation of the server Si no es NULL, es el nombre del permiso en la clase principal que implica los otros permisos en esa clase.If not NULL, this is the name of the permission on the parent class that implies all other permissions on that class.

Tipos de permisosPermission Types

Tipo de permisoPermission type Nombre de permisoPermission name Se aplica al elemento protegible o la claseApplies to securable or class
AADSAADS ALTER ANY DATABASE EVENT SESSIONALTER ANY DATABASE EVENT SESSION
Se aplica a: SQL ServerSQL Server (SQL Server 2014 (12.x)SQL Server 2014 (12.x) a través de la versión actual).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
Se aplica a: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) a través de la versión actual).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
Se aplica a: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) a través de la versión actual).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
Se aplica a: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) a través de la versión actual).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
Se aplica a: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) a través de la versión actual).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
Se aplica a t o: SQL Server 2017 (14.x)SQL Server 2017 (14.x) y 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 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
Se aplica a: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) a través de la versión actual).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
Se aplica a: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) a través de la versión actual).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
Se aplica a: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) a través de la versión actual).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
Se aplica a: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) a través de la versión actual).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
Se aplica a: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) a través de la versión actual).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 POLICYALTER ANY SECURITY POLICY
Se aplica a: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) a través de la versión actual).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
Se aplica a: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) a través de la versión actual).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
Se aplica a: SQL ServerSQL Server (SQL Server 2014 (12.x)SQL Server 2014 (12.x) a través de la versión actual).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
Se aplica a: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) a través de la versión actual).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
Se aplica a: SQL Server 2017 (14.x)SQL Server 2017 (14.x) y 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 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
Se aplica a: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) a través de la versión actual).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 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 Crear grupo de disponibilidadCREATE AVAILABILITY GROUP
Se aplica a: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) a través de la versión actual).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
Se aplica a: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) a través de la versión actual).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
Se aplica a: SQL DatabaseSQL Database.Applies to: SQL DatabaseSQL Database.
DATABASEDATABASE
DLDL DeleteDELETE DATABASEDATABASE
DLDL DeleteDELETE OBJECTOBJECT
DLDL DeleteDELETE SCHEMASCHEMA
EAESEAES EXECUTE ANY EXTERNAL SCRIPTEXECUTE ANY EXTERNAL SCRIPT
Se aplica a: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) a través de la versión actual).Applies to: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) through current version).
DATABASEDATABASE
EXEX EjecuteEXECUTE DATABASEDATABASE
EXEX EjecuteEXECUTE OBJECTOBJECT
EXEX EjecuteEXECUTE SCHEMASCHEMA
EXEX EjecuteEXECUTE TYPETYPE
EXEX EjecuteEXECUTE XML SCHEMA COLLECTIONXML SCHEMA COLLECTION
IALIAL IMPERSONATE ANY LOGINIMPERSONATE ANY LOGIN
Se aplica a: SQL ServerSQL Server (SQL Server 2014 (12.x)SQL Server 2014 (12.x) a través de la versión actual).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
Se aplica a: Base de datos SQL de AzureAzure SQL Database.Applies to: Base de datos SQL de AzureAzure 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
Se aplica a: SQL Server 2017 (14.x)SQL Server 2017 (14.x) y 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 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 ENVIARSEND SERVICESERVICE
SPLNSPLN SHOWPLANSHOWPLAN DATABASEDATABASE
SUQNSUQN SUBSCRIBE QUERY NOTIFICATIONSSUBSCRIBE QUERY NOTIFICATIONS DATABASEDATABASE
SUSSUS SELECT ALL USER SECURABLESSELECT ALL USER SECURABLES
Se aplica a: SQL ServerSQL Server (SQL Server 2014 (12.x)SQL Server 2014 (12.x) a través de la versión actual).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
Se aplica a: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) a través de la versión actual).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
Se aplica a: SQL Server 2017 (14.x)SQL Server 2017 (14.x) y 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
Se aplica a: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) a través de la versión actual).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
Se aplica a: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) a través de la versión actual).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
Se aplica a: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) a través de la versión actual).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
Se aplica a: SQL Server 2017 (14.x)SQL Server 2017 (14.x) y 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 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
Se aplica a: SQL ServerSQL Server (SQL Server 2012 (11.x)SQL Server 2012 (11.x) a través de la versión actual).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 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
Se aplica a: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) a través de la versión actual).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
Se aplica a: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) a través de la versión actual).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

ComentariosRemarks

sys.fn_builtin_permissions es una función con valores de tabla que emite una copia de la jerarquía de permisos predefinida.sys.fn_builtin_permissions is a table-valued function that emits a copy of the predefined permission hierarchy. Esta jerarquía incluye los permisos que cubre.This hierarchy includes covering permissions. El DEFAULT conjunto de resultados describe un gráfico acíclico dirigido de la jerarquía de permisos, de los cuales es la raíz (clase = SERVER, permiso = 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 no acepta parámetros correlacionados.sys.fn_builtin_permissions does not accept correlated parameters.

sys.fn_builtin_permissions devolverá un conjunto vacío cuando se llame con un nombre de clase que no sea válido.sys.fn_builtin_permissions will return an empty set when it is called with a class name that is not valid.

El gráfico siguiente muestra los permisos y las relaciones entre ellos.The following graphic shows the permissions and their relationships to each other. Algunos de los permisos de nivel superior (como CONTROL SERVER) se muestran varias veces.Some of the higher level permissions (such as CONTROL SERVER) are listed many times. En este artículo, el póster es demasiado pequeño para leerlo.In this article, the poster is far too small to read. Haga clic en la imagen para descargar el póster de los permisos de los motores de bases de datos en formato pdf.Click the image to download the Database Engine Permissions Poster in pdf format.

Permisos de los motores de bases de datosDatabase Engine Permissions

PermisosPermissions

Debe pertenecer al rol public.Requires membership in the public role.

EjemplosExamples

A.A. Mostrar todos los permisos integradosListing all built in permissions

Use DEFAULT o una cadena vacía para devolver todos los permisos.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. Mostrar los permisos que se pueden establecer en una clave simétricaListing permissions that can be set on a symmetric key

Especifique una clase para devolver todos los permisos posibles para esa clase.Specify a class to return all possible permissions for that class.

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

C.C. Mostrar las clases donde existe un permiso SELECTListing classes on which there is a SELECT permission

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

Vea tambiénSee Also

Jerarquía de permisos (motor de base de datos) Permissions Hierarchy (Database Engine)
GRANT (Transact-SQL) GRANT (Transact-SQL)
CREATE SCHEMA (Transact-SQL) CREATE SCHEMA (Transact-SQL)
DROP SCHEMA (Transact-SQL) DROP SCHEMA (Transact-SQL)
Permisos (motor de base de datos) 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)