SQL-DMO
Role Constants (SQLDMO_DBUSERROLE_TYPE)
Role constants are reserved for internal use.
Database Roles
| Constant | Value | Description |
|---|---|---|
| SQLDMORole_db_accessadmin | 128 | Database access administrator |
| SQLDMORole_db_backupoperator | 4096 | Database backup operator |
| SQLDMORole_db_datareader | 256 | Database data reader |
| SQLDMORole_db_datawriter | 32768 | Database data writer |
| SQLDMORole_db_ddladmin | 512 | Database DDL administrator |
| SQLDMORole_db_denydatareader | 1024 | Database deny data reader |
| SQLDMORole_db_denydatawriter | 2048 | Database deny data writer |
| SQLDMORole_db_owner | 8192 | Database owner |
| SQLDMORole_db_None | 0 | None |
| SQLDMORole_db_securityadmin | 16384 | Database security administrator |
Server Roles
| Constant | Value | Description |
|---|---|---|
| SQLDMORole_dbcreator | 1 | Database creators |
| SQLDMORole_diskadmin | 2 | Disk administrators |
| SQLDMORole_processadmin | 4 | Process administrators |
| SQLDMORole_securityadmin | 8 | Security administrators |
| SQLDMORole_serveradmin | 16 | Server administrators |
| SQLDMORole_setupadmin | 32 | Setup administrators |
| SQLDMORole_sysadmin | 64 | System administrators |
| SQLDMORole_bulkadmin | 65536 | Bulk insert administrators |