| Login | Type | Scope | Database | DB User | Kind | Permission / Role | State | Class |
|---|---|---|---|---|---|---|---|---|
| CONTOSO\svc_reporting | WINDOWS_LOGIN | Server | Role | public | MEMBER | SERVER_ROLE | ||
| CONTOSO\svc_reporting | WINDOWS_LOGIN | Database | ReportingDB | svc_reporting | Role | db_datareader | MEMBER | DATABASE_ROLE |
| CONTOSO\svc_etl | WINDOWS_LOGIN | Database | SalesDB | svc_etl | Role | db_datareader | MEMBER | DATABASE_ROLE |
| CONTOSO\svc_etl | WINDOWS_LOGIN | Database | SalesDB | svc_etl | Role | db_datawriter | MEMBER | DATABASE_ROLE |
| CONTOSO\svc_etl | WINDOWS_LOGIN | Database | StagingDB | svc_etl | Permission | EXECUTE ON dbo.usp_LoadStage | GRANT | OBJECT_OR_COLUMN |
| app_ro | SQL_LOGIN | Database | SalesDB | app_ro | Role | db_datareader | MEMBER | DATABASE_ROLE |
| app_ro | SQL_LOGIN | Database | SalesDB | app_ro | Permission | CREATE TABLE | DENY | DATABASE |
| backup_operator | SQL_LOGIN | Server | Role | db_backupoperator equivalent (custom) | MEMBER | SERVER_ROLE | ||
| CONTOSO\dba_team | WINDOWS_GROUP | Server | Role | sysadmin | MEMBER | SERVER_ROLE |