Role Constants (SQLDMO_DBUSERROLE_TYPE)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
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 data definition language (DDL) administrator |
SQLDMORole_db_denydatareader |
1024 |
Database deny data reader |
SQLDMORole_db_denydatawriter |
2048 |
Database deny data writer |
SQLDMORole_db_None |
0 |
None |
SQLDMORole_db_owner |
8192 |
Database owner |
SQLDMORole_db_securityadmin |
16384 |
Database security administrator |
Server Roles
Constant |
Value |
Description |
|---|---|---|
SQLDMORole_bulkadmin |
65536 |
Bulk insert administrator |
SQLDMORole_dbcreator |
1 |
Database creator |
SQLDMORole_diskadmin |
2 |
Disk administrator |
SQLDMORole_processadmin |
4 |
Process administrator |
SQLDMORole_securityadmin |
8 |
Security administrator |
SQLDMORole_serveradmin |
16 |
Server administrator |
SQLDMORole_setupadmin |
32 |
Setup administrator |
SQLDMORole_sysadmin |
64 |
System administrator |