Roles

Roles, 10 items

Role NameMemebersIs App Role
public No
db_ownerdboNo
db_accessadmin No
db_securityadmin No
db_ddladmin No
db_backupoperator No
db_datareader No
db_datawriter No
db_denydatareader No
db_denydatawriter No

Permissions for role 'db_owner', 63 items

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

Permissions for role 'db_accessadmin', 5 items

Permission
sp_addalias
sp_dropalias
sp_dropuser
sp_grantdbaccess
sp_revokedbaccess

Permissions for role 'db_securityadmin', 14 items

Permission
DENY
GRANT
REVOKE
sp_addapprole
sp_addgroup
sp_addrole
sp_addrolemember
sp_approlepassword
sp_changegroup
sp_changeobjectowner
sp_dropapprole
sp_dropgroup
sp_droprole
sp_droprolemember

Permissions for role 'db_ddladmin', 12 items

Permission
All DDL but GRANT, REVOKE, DENY
dbcc cleantable
dbcc show_statistics
dbcc showcontig
REFERENCES permission on any table
sp_changeobjectowner
sp_fulltext_column
sp_fulltext_table
sp_recompile
sp_rename
sp_tableoption
TRUNCATE TABLE

Permissions for role 'db_backupoperator', 3 items

Permission
BACKUP DATABASE
BACKUP LOG
CHECKPOINT

Permissions for role 'db_datareader', 1 item

Permission
SELECT permission on any object

Permissions for role 'db_datawriter', 3 items

Permission
DELETE permission on any object
INSERT permission on any object
UPDATE permission on any object

Permissions for role 'db_denydatareader', 1 item

Permission
No SELECT permission on any object

Permissions for role 'db_denydatawriter', 3 items

Permission
No DELETE permission on any object
No INSERT permission on any object
No UPDATE permission on any object