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 |