Class Desc | Permission Name | Type | Covering Permission Name | Parent Class Desc | Parent Covering Permission Name | APPLICATION ROLE | ALTER | AL | CONTROL | DATABASE | ALTER ANY APPLICATION ROLE |
APPLICATION ROLE | CONTROL | CL | | DATABASE | CONTROL |
APPLICATION ROLE | VIEW DEFINITION | VW | CONTROL | DATABASE | VIEW DEFINITION |
ASSEMBLY | ALTER | AL | CONTROL | DATABASE | ALTER ANY ASSEMBLY |
ASSEMBLY | CONTROL | CL | | DATABASE | CONTROL |
ASSEMBLY | REFERENCES | RF | CONTROL | DATABASE | REFERENCES |
ASSEMBLY | TAKE OWNERSHIP | TO | CONTROL | DATABASE | CONTROL |
ASSEMBLY | VIEW DEFINITION | VW | CONTROL | DATABASE | VIEW DEFINITION |
ASYMMETRIC KEY | ALTER | AL | CONTROL | DATABASE | ALTER ANY ASYMMETRIC KEY |
ASYMMETRIC KEY | CONTROL | CL | | DATABASE | CONTROL |
ASYMMETRIC KEY | REFERENCES | RF | CONTROL | DATABASE | REFERENCES |
ASYMMETRIC KEY | TAKE OWNERSHIP | TO | CONTROL | DATABASE | CONTROL |
ASYMMETRIC KEY | VIEW DEFINITION | VW | CONTROL | DATABASE | VIEW DEFINITION |
AVAILABILITY GROUP | ALTER | AL | CONTROL | SERVER | ALTER ANY AVAILABILITY GROUP |
AVAILABILITY GROUP | CONTROL | CL | | SERVER | CONTROL SERVER |
AVAILABILITY GROUP | TAKE OWNERSHIP | TO | CONTROL | SERVER | CONTROL SERVER |
AVAILABILITY GROUP | VIEW DEFINITION | VW | CONTROL | SERVER | VIEW ANY DEFINITION |
CERTIFICATE | ALTER | AL | CONTROL | DATABASE | ALTER ANY CERTIFICATE |
CERTIFICATE | CONTROL | CL | | DATABASE | CONTROL |
CERTIFICATE | REFERENCES | RF | CONTROL | DATABASE | REFERENCES |
CERTIFICATE | TAKE OWNERSHIP | TO | CONTROL | DATABASE | CONTROL |
CERTIFICATE | VIEW DEFINITION | VW | CONTROL | DATABASE | VIEW DEFINITION |
CONTRACT | ALTER | AL | CONTROL | DATABASE | ALTER ANY CONTRACT |
CONTRACT | CONTROL | CL | | DATABASE | CONTROL |
CONTRACT | REFERENCES | RF | CONTROL | DATABASE | REFERENCES |
CONTRACT | TAKE OWNERSHIP | TO | CONTROL | DATABASE | CONTROL |
CONTRACT | VIEW DEFINITION | VW | CONTROL | DATABASE | VIEW DEFINITION |
DATABASE | ALTER | AL | CONTROL | SERVER | ALTER ANY DATABASE |
DATABASE | ALTER ANY APPLICATION ROLE | ALAR | ALTER | SERVER | CONTROL SERVER |
DATABASE | ALTER ANY ASSEMBLY | ALAS | ALTER | SERVER | CONTROL SERVER |
DATABASE | ALTER ANY ASYMMETRIC KEY | ALAK | ALTER | SERVER | CONTROL SERVER |
DATABASE | ALTER ANY CERTIFICATE | ALCF | ALTER | SERVER | CONTROL SERVER |
DATABASE | ALTER ANY CONTRACT | ALSC | ALTER | SERVER | CONTROL SERVER |
DATABASE | ALTER ANY DATABASE AUDIT | ALDA | ALTER | SERVER | ALTER ANY SERVER AUDIT |
DATABASE | ALTER ANY DATABASE DDL TRIGGER | ALTG | ALTER | SERVER | CONTROL SERVER |
DATABASE | ALTER ANY DATABASE EVENT NOTIFICATION | ALED | ALTER | SERVER | ALTER ANY EVENT NOTIFICATION |
DATABASE | ALTER ANY DATASPACE | ALDS | ALTER | SERVER | CONTROL SERVER |
DATABASE | ALTER ANY FULLTEXT CATALOG | ALFT | ALTER | SERVER | CONTROL SERVER |
DATABASE | ALTER ANY MESSAGE TYPE | ALMT | ALTER | SERVER | CONTROL SERVER |
DATABASE | ALTER ANY REMOTE SERVICE BINDING | ALSB | ALTER | SERVER | CONTROL SERVER |
DATABASE | ALTER ANY ROLE | ALRL | ALTER | SERVER | CONTROL SERVER |
DATABASE | ALTER ANY ROUTE | ALRT | ALTER | SERVER | CONTROL SERVER |
DATABASE | ALTER ANY SCHEMA | ALSM | ALTER | SERVER | CONTROL SERVER |
DATABASE | ALTER ANY SERVICE | ALSV | ALTER | SERVER | CONTROL SERVER |
DATABASE | ALTER ANY SYMMETRIC KEY | ALSK | ALTER | SERVER | CONTROL SERVER |
DATABASE | ALTER ANY USER | ALUS | ALTER | SERVER | CONTROL SERVER |
DATABASE | AUTHENTICATE | AUTH | CONTROL | SERVER | AUTHENTICATE SERVER |
DATABASE | BACKUP DATABASE | BADB | CONTROL | SERVER | CONTROL SERVER |
DATABASE | BACKUP LOG | BALO | CONTROL | SERVER | CONTROL SERVER |
DATABASE | CHECKPOINT | CP | CONTROL | SERVER | CONTROL SERVER |
DATABASE | CONNECT | CO | CONNECT REPLICATION | SERVER | CONTROL SERVER |
DATABASE | CONNECT REPLICATION | CORP | CONTROL | SERVER | CONTROL SERVER |
DATABASE | CONTROL | CL | | SERVER | CONTROL SERVER |
DATABASE | CREATE AGGREGATE | CRAG | ALTER | SERVER | CONTROL SERVER |
DATABASE | CREATE ASSEMBLY | CRAS | ALTER ANY ASSEMBLY | SERVER | CONTROL SERVER |
DATABASE | CREATE ASYMMETRIC KEY | CRAK | ALTER ANY ASYMMETRIC KEY | SERVER | CONTROL SERVER |
DATABASE | CREATE CERTIFICATE | CRCF | ALTER ANY CERTIFICATE | SERVER | CONTROL SERVER |
DATABASE | CREATE CONTRACT | CRSC | ALTER ANY CONTRACT | SERVER | CONTROL SERVER |
DATABASE | CREATE DATABASE | CRDB | | SERVER | CREATE ANY DATABASE |
DATABASE | CREATE DATABASE DDL EVENT NOTIFICATION | CRED | ALTER ANY DATABASE EVENT NOTIFICATION | SERVER | CREATE DDL EVENT NOTIFICATION |
DATABASE | CREATE DEFAULT | CRDF | ALTER | SERVER | CONTROL SERVER |
DATABASE | CREATE FULLTEXT CATALOG | CRFT | ALTER ANY FULLTEXT CATALOG | SERVER | CONTROL SERVER |
DATABASE | CREATE FUNCTION | CRFN | ALTER | SERVER | CONTROL SERVER |
DATABASE | CREATE MESSAGE TYPE | CRMT | ALTER ANY MESSAGE TYPE | SERVER | CONTROL SERVER |
DATABASE | CREATE PROCEDURE | CRPR | ALTER | SERVER | CONTROL SERVER |
DATABASE | CREATE QUEUE | CRQU | ALTER | SERVER | CONTROL SERVER |
DATABASE | CREATE REMOTE SERVICE BINDING | CRSB | ALTER ANY REMOTE SERVICE BINDING | SERVER | CONTROL SERVER |
DATABASE | CREATE ROLE | CRRL | ALTER ANY ROLE | SERVER | CONTROL SERVER |
DATABASE | CREATE ROUTE | CRRT | ALTER ANY ROUTE | SERVER | CONTROL SERVER |
DATABASE | CREATE RULE | CRRU | ALTER | SERVER | CONTROL SERVER |
DATABASE | CREATE SCHEMA | CRSM | ALTER ANY SCHEMA | SERVER | CONTROL SERVER |
DATABASE | CREATE SERVICE | CRSV | ALTER ANY SERVICE | SERVER | CONTROL SERVER |
DATABASE | CREATE SYMMETRIC KEY | CRSK | ALTER ANY SYMMETRIC KEY | SERVER | CONTROL SERVER |
DATABASE | CREATE SYNONYM | CRSN | ALTER | SERVER | CONTROL SERVER |
DATABASE | CREATE TABLE | CRTB | ALTER | SERVER | CONTROL SERVER |
DATABASE | CREATE TYPE | CRTY | ALTER | SERVER | CONTROL SERVER |
DATABASE | CREATE VIEW | CRVW | ALTER | SERVER | CONTROL SERVER |
DATABASE | CREATE XML SCHEMA COLLECTION | CRXS | ALTER | SERVER | CONTROL SERVER |
DATABASE | DELETE | DL | CONTROL | SERVER | CONTROL SERVER |
DATABASE | EXECUTE | EX | CONTROL | SERVER | CONTROL SERVER |
DATABASE | INSERT | IN | CONTROL | SERVER | CONTROL SERVER |
DATABASE | REFERENCES | RF | CONTROL | SERVER | CONTROL SERVER |
DATABASE | SELECT | SL | CONTROL | SERVER | CONTROL SERVER |
DATABASE | SHOWPLAN | SPLN | CONTROL | SERVER | ALTER TRACE |
DATABASE | SUBSCRIBE QUERY NOTIFICATIONS | SUQN | CONTROL | SERVER | CONTROL SERVER |
DATABASE | TAKE OWNERSHIP | TO | CONTROL | SERVER | CONTROL SERVER |
DATABASE | UPDATE | UP | CONTROL | SERVER | CONTROL SERVER |
DATABASE | VIEW DATABASE STATE | VWDS | CONTROL | SERVER | VIEW SERVER STATE |
DATABASE | VIEW DEFINITION | VW | CONTROL | SERVER | VIEW ANY DEFINITION |
ENDPOINT | ALTER | AL | CONTROL | SERVER | ALTER ANY ENDPOINT |
ENDPOINT | CONNECT | CO | CONTROL | SERVER | CONTROL SERVER |
ENDPOINT | CONTROL | CL | | SERVER | CONTROL SERVER |
ENDPOINT | TAKE OWNERSHIP | TO | CONTROL | SERVER | CONTROL SERVER |
ENDPOINT | VIEW DEFINITION | VW | CONTROL | SERVER | VIEW ANY DEFINITION |
FULLTEXT CATALOG | ALTER | AL | CONTROL | DATABASE | ALTER ANY FULLTEXT CATALOG |
FULLTEXT CATALOG | CONTROL | CL | | DATABASE | CONTROL |
FULLTEXT CATALOG | REFERENCES | RF | CONTROL | DATABASE | REFERENCES |
FULLTEXT CATALOG | TAKE OWNERSHIP | TO | CONTROL | DATABASE | CONTROL |
FULLTEXT CATALOG | VIEW DEFINITION | VW | CONTROL | DATABASE | VIEW DEFINITION |
FULLTEXT STOPLIST | ALTER | AL | CONTROL | DATABASE | ALTER ANY FULLTEXT CATALOG |
FULLTEXT STOPLIST | CONTROL | CL | | DATABASE | CONTROL |
FULLTEXT STOPLIST | REFERENCES | RF | CONTROL | DATABASE | REFERENCES |
FULLTEXT STOPLIST | TAKE OWNERSHIP | TO | CONTROL | DATABASE | CONTROL |
FULLTEXT STOPLIST | VIEW DEFINITION | VW | CONTROL | DATABASE | VIEW DEFINITION |
LOGIN | ALTER | AL | CONTROL | SERVER | ALTER ANY LOGIN |
LOGIN | CONTROL | CL | | SERVER | CONTROL SERVER |
LOGIN | IMPERSONATE | IM | CONTROL | SERVER | CONTROL SERVER |
LOGIN | VIEW DEFINITION | VW | CONTROL | SERVER | VIEW ANY DEFINITION |
MESSAGE TYPE | ALTER | AL | CONTROL | DATABASE | ALTER ANY MESSAGE TYPE |
MESSAGE TYPE | CONTROL | CL | | DATABASE | CONTROL |
MESSAGE TYPE | REFERENCES | RF | CONTROL | DATABASE | REFERENCES |
MESSAGE TYPE | TAKE OWNERSHIP | TO | CONTROL | DATABASE | CONTROL |
MESSAGE TYPE | VIEW DEFINITION | VW | CONTROL | DATABASE | VIEW DEFINITION |
OBJECT | ALTER | AL | CONTROL | SCHEMA | ALTER |
OBJECT | CONTROL | CL | | SCHEMA | CONTROL |
OBJECT | DELETE | DL | CONTROL | SCHEMA | DELETE |
OBJECT | EXECUTE | EX | CONTROL | SCHEMA | EXECUTE |
OBJECT | INSERT | IN | CONTROL | SCHEMA | INSERT |
OBJECT | RECEIVE | RC | CONTROL | SCHEMA | CONTROL |
OBJECT | REFERENCES | RF | CONTROL | SCHEMA | REFERENCES |
OBJECT | SELECT | SL | RECEIVE | SCHEMA | SELECT |
OBJECT | TAKE OWNERSHIP | TO | CONTROL | SCHEMA | CONTROL |
OBJECT | UPDATE | UP | CONTROL | SCHEMA | UPDATE |
OBJECT | VIEW CHANGE TRACKING | VWCT | CONTROL | SCHEMA | VIEW CHANGE TRACKING |
OBJECT | VIEW DEFINITION | VW | CONTROL | SCHEMA | VIEW DEFINITION |
REMOTE SERVICE BINDING | ALTER | AL | CONTROL | DATABASE | ALTER ANY REMOTE SERVICE BINDING |
REMOTE SERVICE BINDING | CONTROL | CL | | DATABASE | CONTROL |
REMOTE SERVICE BINDING | TAKE OWNERSHIP | TO | CONTROL | DATABASE | CONTROL |
REMOTE SERVICE BINDING | VIEW DEFINITION | VW | CONTROL | DATABASE | VIEW DEFINITION |
ROLE | ALTER | AL | CONTROL | DATABASE | ALTER ANY ROLE |
ROLE | CONTROL | CL | | DATABASE | CONTROL |
ROLE | TAKE OWNERSHIP | TO | CONTROL | DATABASE | CONTROL |
ROLE | VIEW DEFINITION | VW | CONTROL | DATABASE | VIEW DEFINITION |
ROUTE | ALTER | AL | CONTROL | DATABASE | ALTER ANY ROUTE |
ROUTE | CONTROL | CL | | DATABASE | CONTROL |
ROUTE | TAKE OWNERSHIP | TO | CONTROL | DATABASE | CONTROL |
ROUTE | VIEW DEFINITION | VW | CONTROL | DATABASE | VIEW DEFINITION |
SCHEMA | ALTER | AL | CONTROL | DATABASE | ALTER ANY SCHEMA |
SCHEMA | CONTROL | CL | | DATABASE | CONTROL |
SCHEMA | CREATE SEQUENCE | CRSO | ALTER | DATABASE | CONTROL |
SCHEMA | DELETE | DL | CONTROL | DATABASE | DELETE |
SCHEMA | EXECUTE | EX | CONTROL | DATABASE | EXECUTE |
SCHEMA | INSERT | IN | CONTROL | DATABASE | INSERT |
SCHEMA | REFERENCES | RF | CONTROL | DATABASE | REFERENCES |
SCHEMA | SELECT | SL | CONTROL | DATABASE | SELECT |
SCHEMA | TAKE OWNERSHIP | TO | CONTROL | DATABASE | CONTROL |
SCHEMA | UPDATE | UP | CONTROL | DATABASE | UPDATE |
SCHEMA | VIEW CHANGE TRACKING | VWCT | CONTROL | DATABASE | CONTROL |
SCHEMA | VIEW DEFINITION | VW | CONTROL | DATABASE | VIEW DEFINITION |
SEARCH PROPERTY LIST | ALTER | AL | CONTROL | DATABASE | ALTER ANY FULLTEXT CATALOG |
SEARCH PROPERTY LIST | CONTROL | CL | | DATABASE | CONTROL |
SEARCH PROPERTY LIST | REFERENCES | RF | CONTROL | DATABASE | REFERENCES |
SEARCH PROPERTY LIST | TAKE OWNERSHIP | TO | CONTROL | DATABASE | CONTROL |
SEARCH PROPERTY LIST | VIEW DEFINITION | VW | CONTROL | DATABASE | VIEW DEFINITION |
SERVER | ADMINISTER BULK OPERATIONS | ADBO | CONTROL SERVER | | |
SERVER | ALTER ANY AVAILABILITY GROUP | ALAG | CONTROL SERVER | | |
SERVER | ALTER ANY CONNECTION | ALCO | CONTROL SERVER | | |
SERVER | ALTER ANY CREDENTIAL | ALCD | CONTROL SERVER | | |
SERVER | ALTER ANY DATABASE | ALDB | CONTROL SERVER | | |
SERVER | ALTER ANY ENDPOINT | ALHE | CONTROL SERVER | | |
SERVER | ALTER ANY EVENT NOTIFICATION | ALES | CONTROL SERVER | | |
SERVER | ALTER ANY EVENT SESSION | AAES | CONTROL SERVER | | |
SERVER | ALTER ANY LINKED SERVER | ALLS | CONTROL SERVER | | |
SERVER | ALTER ANY LOGIN | ALLG | CONTROL SERVER | | |
SERVER | ALTER ANY SERVER AUDIT | ALAA | CONTROL SERVER | | |
SERVER | ALTER ANY SERVER ROLE | ALSR | CONTROL SERVER | | |
SERVER | ALTER RESOURCES | ALRS | CONTROL SERVER | | |
SERVER | ALTER SERVER STATE | ALSS | CONTROL SERVER | | |
SERVER | ALTER SETTINGS | ALST | CONTROL SERVER | | |
SERVER | ALTER TRACE | ALTR | CONTROL SERVER | | |
SERVER | AUTHENTICATE SERVER | AUTH | CONTROL SERVER | | |
SERVER | CONNECT SQL | COSQ | CONTROL SERVER | | |
SERVER | CONTROL SERVER | CL | | | |
SERVER | CREATE ANY DATABASE | CRDB | ALTER ANY DATABASE | | |
SERVER | CREATE AVAILABILITY GROUP | CRAC | ALTER ANY AVAILABILITY GROUP | | |
SERVER | CREATE DDL EVENT NOTIFICATION | CRDE | ALTER ANY EVENT NOTIFICATION | | |
SERVER | CREATE ENDPOINT | CRHE | ALTER ANY ENDPOINT | | |
SERVER | CREATE SERVER ROLE | CRSR | ALTER ANY SERVER ROLE | | |
SERVER | CREATE TRACE EVENT NOTIFICATION | CRTE | ALTER ANY EVENT NOTIFICATION | | |
SERVER | EXTERNAL ACCESS ASSEMBLY | XA | UNSAFE ASSEMBLY | | |
SERVER | SHUTDOWN | SHDN | CONTROL SERVER | | |
SERVER | UNSAFE ASSEMBLY | XU | CONTROL SERVER | | |
SERVER | VIEW ANY DATABASE | VWDB | VIEW ANY DEFINITION | | |
SERVER | VIEW ANY DEFINITION | VWAD | CONTROL SERVER | | |
SERVER | VIEW SERVER STATE | VWSS | ALTER SERVER STATE | | |
SERVER ROLE | ALTER | AL | CONTROL | SERVER | ALTER ANY SERVER ROLE |
SERVER ROLE | CONTROL | CL | | SERVER | CONTROL SERVER |
SERVER ROLE | TAKE OWNERSHIP | TO | CONTROL | SERVER | CONTROL SERVER |
SERVER ROLE | VIEW DEFINITION | VW | CONTROL | SERVER | VIEW ANY DEFINITION |
SERVICE | ALTER | AL | CONTROL | DATABASE | ALTER ANY SERVICE |
SERVICE | CONTROL | CL | | DATABASE | CONTROL |
SERVICE | SEND | SN | CONTROL | DATABASE | CONTROL |
SERVICE | TAKE OWNERSHIP | TO | CONTROL | DATABASE | CONTROL |
SERVICE | VIEW DEFINITION | VW | CONTROL | DATABASE | VIEW DEFINITION |
SYMMETRIC KEY | ALTER | AL | CONTROL | DATABASE | ALTER ANY SYMMETRIC KEY |
SYMMETRIC KEY | CONTROL | CL | | DATABASE | CONTROL |
SYMMETRIC KEY | REFERENCES | RF | CONTROL | DATABASE | REFERENCES |
SYMMETRIC KEY | TAKE OWNERSHIP | TO | CONTROL | DATABASE | CONTROL |
SYMMETRIC KEY | VIEW DEFINITION | VW | CONTROL | DATABASE | VIEW DEFINITION |
TYPE | CONTROL | CL | | SCHEMA | CONTROL |
TYPE | EXECUTE | EX | CONTROL | SCHEMA | EXECUTE |
TYPE | REFERENCES | RF | CONTROL | SCHEMA | REFERENCES |
TYPE | TAKE OWNERSHIP | TO | CONTROL | SCHEMA | CONTROL |
TYPE | VIEW DEFINITION | VW | CONTROL | SCHEMA | VIEW DEFINITION |
USER | ALTER | AL | CONTROL | DATABASE | ALTER ANY USER |
USER | CONTROL | CL | | DATABASE | CONTROL |
USER | IMPERSONATE | IM | CONTROL | DATABASE | CONTROL |
USER | VIEW DEFINITION | VW | CONTROL | DATABASE | VIEW DEFINITION |
XML SCHEMA COLLECTION | ALTER | AL | CONTROL | SCHEMA | ALTER |
XML SCHEMA COLLECTION | CONTROL | CL | | SCHEMA | CONTROL |
XML SCHEMA COLLECTION | EXECUTE | EX | CONTROL | SCHEMA | EXECUTE |
XML SCHEMA COLLECTION | REFERENCES | RF | CONTROL | SCHEMA | REFERENCES |
XML SCHEMA COLLECTION | TAKE OWNERSHIP | TO | CONTROL | SCHEMA | CONTROL |
XML SCHEMA COLLECTION | VIEW DEFINITION | VW | CONTROL | SCHEMA | VIEW DEFINITION |
No comments:
Post a Comment