List of roles
Roles
| Name | Role type | Users and roles with this role |
| [db_accessadmin] | User-defined role | |
| [db_backupoperator] | User-defined role | |
| [db_datareader] | User-defined role | |
| [db_datawriter] | User-defined role | |
| [db_ddladmin] | User-defined role | |
| [db_denydatareader] | User-defined role | |
| [db_denydatawriter] | User-defined role | |
| [db_owner] | User-defined role | dbo |
| [db_securityadmin] | User-defined role | |
| [public] | Standard role (built-in) | amy0, brian3, david8, dbo, garrett1, guest, jae0, jillian0, josé1, linda3, lynn0, michael9, pamela0, rachel0, ranjit0, shu0, stephen0, syed0, tete0, tsvi0 |
| [SalesManagers] | User-defined role | amy0, brian3, stephen0, syed0 |
| [SalesPersons] | User-defined role | david8, garrett1, jae0, jillian0, josé1, linda3, lynn0, michael9, pamela0, rachel0, ranjit0, shu0, tete0, tsvi0 |
See also