May 3, 2012

SQL Built In Permissions (fn_builtin_permissions)

Built In Permission on SQL Server


Class DescPermission NameTypeCovering Permission NameParent Class DescParent Covering Permission Name
APPLICATION ROLEALTERAL CONTROLDATABASEALTER ANY APPLICATION ROLE
APPLICATION ROLECONTROLCL  DATABASECONTROL
APPLICATION ROLEVIEW DEFINITIONVW CONTROLDATABASEVIEW DEFINITION
ASSEMBLYALTERAL CONTROLDATABASEALTER ANY ASSEMBLY
ASSEMBLYCONTROLCL  DATABASECONTROL
ASSEMBLYREFERENCESRF CONTROLDATABASEREFERENCES
ASSEMBLYTAKE OWNERSHIPTO CONTROLDATABASECONTROL
ASSEMBLYVIEW DEFINITIONVW CONTROLDATABASEVIEW DEFINITION
ASYMMETRIC KEYALTERAL CONTROLDATABASEALTER ANY ASYMMETRIC KEY
ASYMMETRIC KEYCONTROLCL  DATABASECONTROL
ASYMMETRIC KEYREFERENCESRF CONTROLDATABASEREFERENCES
ASYMMETRIC KEYTAKE OWNERSHIPTO CONTROLDATABASECONTROL
ASYMMETRIC KEYVIEW DEFINITIONVW CONTROLDATABASEVIEW DEFINITION
AVAILABILITY GROUPALTERAL CONTROLSERVERALTER ANY AVAILABILITY GROUP
AVAILABILITY GROUPCONTROLCL  SERVERCONTROL SERVER
AVAILABILITY GROUPTAKE OWNERSHIPTO CONTROLSERVERCONTROL SERVER
AVAILABILITY GROUPVIEW DEFINITIONVW CONTROLSERVERVIEW ANY DEFINITION
CERTIFICATEALTERAL CONTROLDATABASEALTER ANY CERTIFICATE
CERTIFICATECONTROLCL  DATABASECONTROL
CERTIFICATEREFERENCESRF CONTROLDATABASEREFERENCES
CERTIFICATETAKE OWNERSHIPTO CONTROLDATABASECONTROL
CERTIFICATEVIEW DEFINITIONVW CONTROLDATABASEVIEW DEFINITION
CONTRACTALTERAL CONTROLDATABASEALTER ANY CONTRACT
CONTRACTCONTROLCL  DATABASECONTROL
CONTRACTREFERENCESRF CONTROLDATABASEREFERENCES
CONTRACTTAKE OWNERSHIPTO CONTROLDATABASECONTROL
CONTRACTVIEW DEFINITIONVW CONTROLDATABASEVIEW DEFINITION
DATABASEALTERAL CONTROLSERVERALTER ANY DATABASE
DATABASEALTER ANY APPLICATION ROLEALARALTERSERVERCONTROL SERVER
DATABASEALTER ANY ASSEMBLYALASALTERSERVERCONTROL SERVER
DATABASEALTER ANY ASYMMETRIC KEYALAKALTERSERVERCONTROL SERVER
DATABASEALTER ANY CERTIFICATEALCFALTERSERVERCONTROL SERVER
DATABASEALTER ANY CONTRACTALSCALTERSERVERCONTROL SERVER
DATABASEALTER ANY DATABASE AUDITALDAALTERSERVERALTER ANY SERVER AUDIT
DATABASEALTER ANY DATABASE DDL TRIGGERALTGALTERSERVERCONTROL SERVER
DATABASEALTER ANY DATABASE EVENT NOTIFICATIONALEDALTERSERVERALTER ANY EVENT NOTIFICATION
DATABASEALTER ANY DATASPACEALDSALTERSERVERCONTROL SERVER
DATABASEALTER ANY FULLTEXT CATALOGALFTALTERSERVERCONTROL SERVER
DATABASEALTER ANY MESSAGE TYPEALMTALTERSERVERCONTROL SERVER
DATABASEALTER ANY REMOTE SERVICE BINDINGALSBALTERSERVERCONTROL SERVER
DATABASEALTER ANY ROLEALRLALTERSERVERCONTROL SERVER
DATABASEALTER ANY ROUTEALRTALTERSERVERCONTROL SERVER
DATABASEALTER ANY SCHEMAALSMALTERSERVERCONTROL SERVER
DATABASEALTER ANY SERVICEALSVALTERSERVERCONTROL SERVER
DATABASEALTER ANY SYMMETRIC KEYALSKALTERSERVERCONTROL SERVER
DATABASEALTER ANY USERALUSALTERSERVERCONTROL SERVER
DATABASEAUTHENTICATEAUTHCONTROLSERVERAUTHENTICATE SERVER
DATABASEBACKUP DATABASEBADBCONTROLSERVERCONTROL SERVER
DATABASEBACKUP LOGBALOCONTROLSERVERCONTROL SERVER
DATABASECHECKPOINTCP CONTROLSERVERCONTROL SERVER
DATABASECONNECTCO CONNECT REPLICATIONSERVERCONTROL SERVER
DATABASECONNECT REPLICATIONCORPCONTROLSERVERCONTROL SERVER
DATABASECONTROLCL  SERVERCONTROL SERVER
DATABASECREATE AGGREGATECRAGALTERSERVERCONTROL SERVER
DATABASECREATE ASSEMBLYCRASALTER ANY ASSEMBLYSERVERCONTROL SERVER
DATABASECREATE ASYMMETRIC KEYCRAKALTER ANY ASYMMETRIC KEYSERVERCONTROL SERVER
DATABASECREATE CERTIFICATECRCFALTER ANY CERTIFICATESERVERCONTROL SERVER
DATABASECREATE CONTRACTCRSCALTER ANY CONTRACTSERVERCONTROL SERVER
DATABASECREATE DATABASECRDB SERVERCREATE ANY DATABASE
DATABASECREATE DATABASE DDL EVENT NOTIFICATIONCREDALTER ANY DATABASE EVENT NOTIFICATIONSERVERCREATE DDL EVENT NOTIFICATION
DATABASECREATE DEFAULTCRDFALTERSERVERCONTROL SERVER
DATABASECREATE FULLTEXT CATALOGCRFTALTER ANY FULLTEXT CATALOGSERVERCONTROL SERVER
DATABASECREATE FUNCTIONCRFNALTERSERVERCONTROL SERVER
DATABASECREATE MESSAGE TYPECRMTALTER ANY MESSAGE TYPESERVERCONTROL SERVER
DATABASECREATE PROCEDURECRPRALTERSERVERCONTROL SERVER
DATABASECREATE QUEUECRQUALTERSERVERCONTROL SERVER
DATABASECREATE REMOTE SERVICE BINDINGCRSBALTER ANY REMOTE SERVICE BINDINGSERVERCONTROL SERVER
DATABASECREATE ROLECRRLALTER ANY ROLESERVERCONTROL SERVER
DATABASECREATE ROUTECRRTALTER ANY ROUTESERVERCONTROL SERVER
DATABASECREATE RULECRRUALTERSERVERCONTROL SERVER
DATABASECREATE SCHEMACRSMALTER ANY SCHEMASERVERCONTROL SERVER
DATABASECREATE SERVICECRSVALTER ANY SERVICESERVERCONTROL SERVER
DATABASECREATE SYMMETRIC KEYCRSKALTER ANY SYMMETRIC KEYSERVERCONTROL SERVER
DATABASECREATE SYNONYMCRSNALTERSERVERCONTROL SERVER
DATABASECREATE TABLECRTBALTERSERVERCONTROL SERVER
DATABASECREATE TYPECRTYALTERSERVERCONTROL SERVER
DATABASECREATE VIEWCRVWALTERSERVERCONTROL SERVER
DATABASECREATE XML SCHEMA COLLECTIONCRXSALTERSERVERCONTROL SERVER
DATABASEDELETEDL CONTROLSERVERCONTROL SERVER
DATABASEEXECUTEEX CONTROLSERVERCONTROL SERVER
DATABASEINSERTIN CONTROLSERVERCONTROL SERVER
DATABASEREFERENCESRF CONTROLSERVERCONTROL SERVER
DATABASESELECTSL CONTROLSERVERCONTROL SERVER
DATABASESHOWPLANSPLNCONTROLSERVERALTER TRACE
DATABASESUBSCRIBE QUERY NOTIFICATIONSSUQNCONTROLSERVERCONTROL SERVER
DATABASETAKE OWNERSHIPTO CONTROLSERVERCONTROL SERVER
DATABASEUPDATEUP CONTROLSERVERCONTROL SERVER
DATABASEVIEW DATABASE STATEVWDSCONTROLSERVERVIEW SERVER STATE
DATABASEVIEW DEFINITIONVW CONTROLSERVERVIEW ANY DEFINITION
ENDPOINTALTERAL CONTROLSERVERALTER ANY ENDPOINT
ENDPOINTCONNECTCO CONTROLSERVERCONTROL SERVER
ENDPOINTCONTROLCL  SERVERCONTROL SERVER
ENDPOINTTAKE OWNERSHIPTO CONTROLSERVERCONTROL SERVER
ENDPOINTVIEW DEFINITIONVW CONTROLSERVERVIEW ANY DEFINITION
FULLTEXT CATALOGALTERAL CONTROLDATABASEALTER ANY FULLTEXT CATALOG
FULLTEXT CATALOGCONTROLCL  DATABASECONTROL
FULLTEXT CATALOGREFERENCESRF CONTROLDATABASEREFERENCES
FULLTEXT CATALOGTAKE OWNERSHIPTO CONTROLDATABASECONTROL
FULLTEXT CATALOGVIEW DEFINITIONVW CONTROLDATABASEVIEW DEFINITION
FULLTEXT STOPLISTALTERAL CONTROLDATABASEALTER ANY FULLTEXT CATALOG
FULLTEXT STOPLISTCONTROLCL  DATABASECONTROL
FULLTEXT STOPLISTREFERENCESRF CONTROLDATABASEREFERENCES
FULLTEXT STOPLISTTAKE OWNERSHIPTO CONTROLDATABASECONTROL
FULLTEXT STOPLISTVIEW DEFINITIONVW CONTROLDATABASEVIEW DEFINITION
LOGINALTERAL CONTROLSERVERALTER ANY LOGIN
LOGINCONTROLCL  SERVERCONTROL SERVER
LOGINIMPERSONATEIM CONTROLSERVERCONTROL SERVER
LOGINVIEW DEFINITIONVW CONTROLSERVERVIEW ANY DEFINITION
MESSAGE TYPEALTERAL CONTROLDATABASEALTER ANY MESSAGE TYPE
MESSAGE TYPECONTROLCL  DATABASECONTROL
MESSAGE TYPEREFERENCESRF CONTROLDATABASEREFERENCES
MESSAGE TYPETAKE OWNERSHIPTO CONTROLDATABASECONTROL
MESSAGE TYPEVIEW DEFINITIONVW CONTROLDATABASEVIEW DEFINITION
OBJECTALTERAL CONTROLSCHEMAALTER
OBJECTCONTROLCL  SCHEMACONTROL
OBJECTDELETEDL CONTROLSCHEMADELETE
OBJECTEXECUTEEX CONTROLSCHEMAEXECUTE
OBJECTINSERTIN CONTROLSCHEMAINSERT
OBJECTRECEIVERC CONTROLSCHEMACONTROL
OBJECTREFERENCESRF CONTROLSCHEMAREFERENCES
OBJECTSELECTSL RECEIVESCHEMASELECT
OBJECTTAKE OWNERSHIPTO CONTROLSCHEMACONTROL
OBJECTUPDATEUP CONTROLSCHEMAUPDATE
OBJECTVIEW CHANGE TRACKINGVWCTCONTROLSCHEMAVIEW CHANGE TRACKING
OBJECTVIEW DEFINITIONVW CONTROLSCHEMAVIEW DEFINITION
REMOTE SERVICE BINDINGALTERAL CONTROLDATABASEALTER ANY REMOTE SERVICE BINDING
REMOTE SERVICE BINDINGCONTROLCL  DATABASECONTROL
REMOTE SERVICE BINDINGTAKE OWNERSHIPTO CONTROLDATABASECONTROL
REMOTE SERVICE BINDINGVIEW DEFINITIONVW CONTROLDATABASEVIEW DEFINITION
ROLEALTERAL CONTROLDATABASEALTER ANY ROLE
ROLECONTROLCL  DATABASECONTROL
ROLETAKE OWNERSHIPTO CONTROLDATABASECONTROL
ROLEVIEW DEFINITIONVW CONTROLDATABASEVIEW DEFINITION
ROUTEALTERAL CONTROLDATABASEALTER ANY ROUTE
ROUTECONTROLCL  DATABASECONTROL
ROUTETAKE OWNERSHIPTO CONTROLDATABASECONTROL
ROUTEVIEW DEFINITIONVW CONTROLDATABASEVIEW DEFINITION
SCHEMAALTERAL CONTROLDATABASEALTER ANY SCHEMA
SCHEMACONTROLCL  DATABASECONTROL
SCHEMACREATE SEQUENCECRSOALTERDATABASECONTROL
SCHEMADELETEDL CONTROLDATABASEDELETE
SCHEMAEXECUTEEX CONTROLDATABASEEXECUTE
SCHEMAINSERTIN CONTROLDATABASEINSERT
SCHEMAREFERENCESRF CONTROLDATABASEREFERENCES
SCHEMASELECTSL CONTROLDATABASESELECT
SCHEMATAKE OWNERSHIPTO CONTROLDATABASECONTROL
SCHEMAUPDATEUP CONTROLDATABASEUPDATE
SCHEMAVIEW CHANGE TRACKINGVWCTCONTROLDATABASECONTROL
SCHEMAVIEW DEFINITIONVW CONTROLDATABASEVIEW DEFINITION
SEARCH PROPERTY LISTALTERAL CONTROLDATABASEALTER ANY FULLTEXT CATALOG
SEARCH PROPERTY LISTCONTROLCL  DATABASECONTROL
SEARCH PROPERTY LISTREFERENCESRF CONTROLDATABASEREFERENCES
SEARCH PROPERTY LISTTAKE OWNERSHIPTO CONTROLDATABASECONTROL
SEARCH PROPERTY LISTVIEW DEFINITIONVW CONTROLDATABASEVIEW DEFINITION
SERVERADMINISTER BULK OPERATIONSADBOCONTROL SERVER 
SERVERALTER ANY AVAILABILITY GROUPALAGCONTROL SERVER 
SERVERALTER ANY CONNECTIONALCOCONTROL SERVER 
SERVERALTER ANY CREDENTIALALCDCONTROL SERVER 
SERVERALTER ANY DATABASEALDBCONTROL SERVER 
SERVERALTER ANY ENDPOINTALHECONTROL SERVER 
SERVERALTER ANY EVENT NOTIFICATIONALESCONTROL SERVER 
SERVERALTER ANY EVENT SESSIONAAESCONTROL SERVER 
SERVERALTER ANY LINKED SERVERALLSCONTROL SERVER 
SERVERALTER ANY LOGINALLGCONTROL SERVER 
SERVERALTER ANY SERVER AUDITALAACONTROL SERVER 
SERVERALTER ANY SERVER ROLEALSRCONTROL SERVER 
SERVERALTER RESOURCESALRSCONTROL SERVER 
SERVERALTER SERVER STATEALSSCONTROL SERVER 
SERVERALTER SETTINGSALSTCONTROL SERVER 
SERVERALTER TRACEALTRCONTROL SERVER 
SERVERAUTHENTICATE SERVERAUTHCONTROL SERVER 
SERVERCONNECT SQLCOSQCONTROL SERVER 
SERVERCONTROL SERVERCL   
SERVERCREATE ANY DATABASECRDBALTER ANY DATABASE 
SERVERCREATE AVAILABILITY GROUPCRACALTER ANY AVAILABILITY GROUP 
SERVERCREATE DDL EVENT NOTIFICATIONCRDEALTER ANY EVENT NOTIFICATION 
SERVERCREATE ENDPOINTCRHEALTER ANY ENDPOINT 
SERVERCREATE SERVER ROLECRSRALTER ANY SERVER ROLE 
SERVERCREATE TRACE EVENT NOTIFICATIONCRTEALTER ANY EVENT NOTIFICATION 
SERVEREXTERNAL ACCESS ASSEMBLYXA UNSAFE ASSEMBLY 
SERVERSHUTDOWNSHDNCONTROL SERVER 
SERVERUNSAFE ASSEMBLYXU CONTROL SERVER 
SERVERVIEW ANY DATABASEVWDBVIEW ANY DEFINITION 
SERVERVIEW ANY DEFINITIONVWADCONTROL SERVER 
SERVERVIEW SERVER STATEVWSSALTER SERVER STATE 
SERVER ROLEALTERAL CONTROLSERVERALTER ANY SERVER ROLE
SERVER ROLECONTROLCL  SERVERCONTROL SERVER
SERVER ROLETAKE OWNERSHIPTO CONTROLSERVERCONTROL SERVER
SERVER ROLEVIEW DEFINITIONVW CONTROLSERVERVIEW ANY DEFINITION
SERVICEALTERAL CONTROLDATABASEALTER ANY SERVICE
SERVICECONTROLCL  DATABASECONTROL
SERVICESENDSN CONTROLDATABASECONTROL
SERVICETAKE OWNERSHIPTO CONTROLDATABASECONTROL
SERVICEVIEW DEFINITIONVW CONTROLDATABASEVIEW DEFINITION
SYMMETRIC KEYALTERAL CONTROLDATABASEALTER ANY SYMMETRIC KEY
SYMMETRIC KEYCONTROLCL  DATABASECONTROL
SYMMETRIC KEYREFERENCESRF CONTROLDATABASEREFERENCES
SYMMETRIC KEYTAKE OWNERSHIPTO CONTROLDATABASECONTROL
SYMMETRIC KEYVIEW DEFINITIONVW CONTROLDATABASEVIEW DEFINITION
TYPECONTROLCL  SCHEMACONTROL
TYPEEXECUTEEX CONTROLSCHEMAEXECUTE
TYPEREFERENCESRF CONTROLSCHEMAREFERENCES
TYPETAKE OWNERSHIPTO CONTROLSCHEMACONTROL
TYPEVIEW DEFINITIONVW CONTROLSCHEMAVIEW DEFINITION
USERALTERAL CONTROLDATABASEALTER ANY USER
USERCONTROLCL  DATABASECONTROL
USERIMPERSONATEIM CONTROLDATABASECONTROL
USERVIEW DEFINITIONVW CONTROLDATABASEVIEW DEFINITION
XML SCHEMA COLLECTIONALTERAL CONTROLSCHEMAALTER
XML SCHEMA COLLECTIONCONTROLCL  SCHEMACONTROL
XML SCHEMA COLLECTIONEXECUTEEX CONTROLSCHEMAEXECUTE
XML SCHEMA COLLECTIONREFERENCESRF CONTROLSCHEMAREFERENCES
XML SCHEMA COLLECTIONTAKE OWNERSHIPTO CONTROLSCHEMACONTROL
XML SCHEMA COLLECTIONVIEW DEFINITIONVW CONTROLSCHEMAVIEW DEFINITION


Built In Permission Tree Structure


  • Server [CL] Control Server
  • Server [ADBO] Administer Bulk Operations
    • Server [ALAG] Alter Any Availability Group
    • Availability Group [AL] Alter
  • Server [ALCO] Alter Any Connection
  • Server [ALCD] Alter Any Credential
    • Server [ALDB] Alter Any Database
    • Database [AL] Alter
    • Server [ALHE] Alter Any Endpoint
    • Endpoint [AL] Alter
    • Server [ALES] Alter Any Event Notification
    • Database [ALED] Alter Any Database Event Notification
  • Server [AAES] Alter Any Event Session
  • Server [ALLS] Alter Any Linked Server
    • Server [ALLG] Alter Any Login
    • Login [AL] Alter
    • Server [ALAA] Alter Any Server Audit
    • Database [ALDA] Alter Any Database Audit
    • Server [ALSR] Alter Any Server Role
    • Server Role [AL] Alter
  • Server [ALRS] Alter Resources
  • Server [ALSS] Alter Server State
  • Server [ALST] Alter Settings
    • Server [ALTR] Alter Trace
    • Database [SPLN] Showplan
    • Server [AUTH] Authenticate Server
    • Database [AUTH] Authenticate
  • Server [COSQ] Connect Sql
  • Server [SHDN] Shutdown
  • Server [XU] Unsafe Assembly
    • Server [VWAD] View Any Definition
    • Availability Group [VW] View Definition
      • Database [VW] View Definition
      • Application Role [VW] View Definition
      • Assembly [VW] View Definition
      • Asymmetric Key [VW] View Definition
      • Certificate [VW] View Definition
      • Contract [VW] View Definition
      • Fulltext Catalog [VW] View Definition
      • Fulltext Stoplist [VW] View Definition
      • Message Type [VW] View Definition
      • Remote Service Binding [VW] View Definition
      • Role [VW] View Definition
      • Route [VW] View Definition
        • Schema [VW] View Definition
        • Object [VW] View Definition
        • Type [VW] View Definition
        • Xml Schema Collection [VW] View Definition
      • Search Property List [VW] View Definition
      • Service [VW] View Definition
      • Symmetric Key [VW] View Definition
      • User [VW] View Definition
    • Endpoint [VW] View Definition
    • Login [VW] View Definition
    • Server Role [VW] View Definition
  • Availability Group [CL] Control
    • Database [CL] Control
    • Application Role [CL] Control
    • Assembly [CL] Control
    • Assembly [TO] Take Ownership
    • Asymmetric Key [CL] Control
    • Asymmetric Key [TO] Take Ownership
    • Certificate [CL] Control
    • Certificate [TO] Take Ownership
    • Contract [CL] Control
    • Contract [TO] Take Ownership
    • Fulltext Catalog [CL] Control
    • Fulltext Catalog [TO] Take Ownership
    • Fulltext Stoplist [CL] Control
    • Fulltext Stoplist [TO] Take Ownership
    • Message Type [CL] Control
    • Message Type [TO] Take Ownership
    • Remote Service Binding [CL] Control
    • Remote Service Binding [TO] Take Ownership
    • Role [CL] Control
    • Role [TO] Take Ownership
    • Route [CL] Control
    • Route [TO] Take Ownership
      • Schema [CL] Control
      • Object [CL] Control
      • Object [RC] Receive
      • Object [TO] Take Ownership
      • Type [CL] Control
      • Type [TO] Take Ownership
      • Xml Schema Collection [CL] Control
      • Xml Schema Collection [TO] Take Ownership
    • Schema [CRSO] Create Sequence
    • Schema [TO] Take Ownership
      • Schema [VWCT] View Change Tracking
      • Object [VWCT] View Change Tracking
    • Search Property List [CL] Control
    • Search Property List [TO] Take Ownership
    • Service [CL] Control
    • Service [SN] Send
    • Service [TO] Take Ownership
    • Symmetric Key [CL] Control
    • Symmetric Key [TO] Take Ownership
    • User [CL] Control
    • User [IM] Impersonate
  • Endpoint [CL] Control
  • Login [CL] Control
  • Server Role [CL] Control
  • Availability Group [CL] Control
  • Availability Group [TO] Take Ownership
    • Database [ALAR] Alter Any Application Role
    • Application Role [AL] Alter
    • Database [ALAS] Alter Any Assembly
    • Assembly [AL] Alter
    • Database [ALAK] Alter Any Asymmetric Key
    • Asymmetric Key [AL] Alter
    • Database [ALCF] Alter Any Certificate
    • Certificate [AL] Alter
    • Database [ALSC] Alter Any Contract
    • Contract [AL] Alter
  • Database [ALTG] Alter Any Database Ddl Trigger
  • Database [ALDS] Alter Any Dataspace
    • Database [ALFT] Alter Any Fulltext Catalog
    • Fulltext Catalog [AL] Alter
    • Fulltext Stoplist [AL] Alter
    • Search Property List [AL] Alter
    • Database [ALMT] Alter Any Message Type
    • Message Type [AL] Alter
    • Database [ALSB] Alter Any Remote Service Binding
    • Remote Service Binding [AL] Alter
    • Database [ALRL] Alter Any Role
    • Role [AL] Alter
    • Database [ALRT] Alter Any Route
    • Route [AL] Alter
    • Database [ALSM] Alter Any Schema
      • Schema [AL] Alter
      • Object [AL] Alter
      • Xml Schema Collection [AL] Alter
    • Database [ALSV] Alter Any Service
    • Service [AL] Alter
    • Database [ALSK] Alter Any Symmetric Key
    • Symmetric Key [AL] Alter
    • Database [ALUS] Alter Any User
    • User [AL] Alter
  • Database [BADB] Backup Database
  • Database [BALO] Backup Log
  • Database [CP] Checkpoint
  • Database [CO] Connect
  • Database [CORP] Connect Replication
    • Database [CL] Control
    • Application Role [CL] Control
    • Assembly [CL] Control
    • Assembly [TO] Take Ownership
    • Asymmetric Key [CL] Control
    • Asymmetric Key [TO] Take Ownership
    • Certificate [CL] Control
    • Certificate [TO] Take Ownership
    • Contract [CL] Control
    • Contract [TO] Take Ownership
    • Fulltext Catalog [CL] Control
    • Fulltext Catalog [TO] Take Ownership
    • Fulltext Stoplist [CL] Control
    • Fulltext Stoplist [TO] Take Ownership
    • Message Type [CL] Control
    • Message Type [TO] Take Ownership
    • Remote Service Binding [CL] Control
    • Remote Service Binding [TO] Take Ownership
    • Role [CL] Control
    • Role [TO] Take Ownership
    • Route [CL] Control
    • Route [TO] Take Ownership
      • Schema [CL] Control
      • Object [CL] Control
      • Object [RC] Receive
      • Object [TO] Take Ownership
      • Type [CL] Control
      • Type [TO] Take Ownership
      • Xml Schema Collection [CL] Control
      • Xml Schema Collection [TO] Take Ownership
    • Schema [CRSO] Create Sequence
    • Schema [TO] Take Ownership
      • Schema [VWCT] View Change Tracking
      • Object [VWCT] View Change Tracking
    • Search Property List [CL] Control
    • Search Property List [TO] Take Ownership
    • Service [CL] Control
    • Service [SN] Send
    • Service [TO] Take Ownership
    • Symmetric Key [CL] Control
    • Symmetric Key [TO] Take Ownership
    • User [CL] Control
    • User [IM] Impersonate
  • Database [CRAG] Create Aggregate
  • Database [CRAS] Create Assembly
  • Database [CRAK] Create Asymmetric Key
  • Database [CRCF] Create Certificate
  • Database [CRSC] Create Contract
  • Database [CRDF] Create Default
  • Database [CRFT] Create Fulltext Catalog
  • Database [CRFN] Create Function
  • Database [CRMT] Create Message Type
  • Database [CRPR] Create Procedure
  • Database [CRQU] Create Queue
  • Database [CRSB] Create Remote Service Binding
  • Database [CRRL] Create Role
  • Database [CRRT] Create Route
  • Database [CRRU] Create Rule
  • Database [CRSM] Create Schema
  • Database [CRSV] Create Service
  • Database [CRSK] Create Symmetric Key
  • Database [CRSN] Create Synonym
  • Database [CRTB] Create Table
  • Database [CRTY] Create Type
  • Database [CRVW] Create View
  • Database [CRXS] Create Xml Schema Collection
    • Database [DL] Delete
      • Schema [DL] Delete
      • Object [DL] Delete
    • Database [EX] Execute
      • Schema [EX] Execute
      • Object [EX] Execute
      • Type [EX] Execute
      • Xml Schema Collection [EX] Execute
    • Database [IN] Insert
      • Schema [IN] Insert
      • Object [IN] Insert
    • Database [RF] References
    • Assembly [RF] References
    • Asymmetric Key [RF] References
    • Certificate [RF] References
    • Contract [RF] References
    • Fulltext Catalog [RF] References
    • Fulltext Stoplist [RF] References
    • Message Type [RF] References
      • Schema [RF] References
      • Object [RF] References
      • Type [RF] References
      • Xml Schema Collection [RF] References
    • Search Property List [RF] References
    • Symmetric Key [RF] References
    • Database [SL] Select
      • Schema [SL] Select
      • Object [SL] Select
  • Database [SUQN] Subscribe Query Notifications
  • Database [TO] Take Ownership
    • Database [UP] Update
      • Schema [UP] Update
      • Object [UP] Update
  • Endpoint [CO] Connect
  • Endpoint [CL] Control
  • Endpoint [TO] Take Ownership
  • Login [CL] Control
  • Login [IM] Impersonate
  • Server Role [CL] Control
  • Server Role [TO] Take Ownership

No comments:

Post a Comment

Total Pageviews