Permission |
Add/drop to/from db_accessadmin |
Add/drop to/from db_backupoperator |
Add/drop to/from db_datareader |
Add/drop to/from db_datawriter |
Add/drop to/from db_ddladmin |
Add/drop to/from db_denydatareader |
Add/drop to/from db_denydatawriter |
Add/drop to/from db_owner |
Add/drop to/from db_securityadmin |
All DDL but GRANT, REVOKE, DENY |
BACKUP DATABASE |
BACKUP LOG |
CHECKPOINT |
dbcc checkalloc |
dbcc checkdb |
dbcc checkfilegroup |
dbcc checkident |
dbcc checktable |
dbcc cleantable |
dbcc dbreindex |
dbcc proccache |
dbcc show_statistics |
dbcc showcontig |
dbcc shrinkdatabase |
dbcc shrinkfile |
dbcc updateusage |
DELETE permission on any object |
DENY |
EXECUTE any procedure |
GRANT |
INSERT permission on any object |
REFERENCES permission on any table |
REVOKE |
SELECT permission on any object |
sp_addalias |
sp_addapprole |
sp_addgroup |
sp_addrole |
sp_addrolemember |
sp_approlepassword |
sp_change_users_login |
sp_changegroup |
sp_changeobjectowner |
sp_dbcmptlevel |
sp_dboption (update) |
sp_dropalias |
sp_dropapprole |
sp_dropgroup |
sp_droprole |
sp_droprolemember |
sp_dropuser |
sp_fulltext_catalog |
sp_fulltext_column |
sp_fulltext_database |
sp_fulltext_table |
sp_grantdbaccess |
sp_recompile |
sp_refreshview |
sp_rename |
sp_revokedbaccess |
sp_tableoption |
TRUNCATE TABLE |
UPDATE permission on any object |