Role Constants (SQLDMO_DBUSERROLE_TYPE)

Role constants are reserved for future use.

Constant Value Description
SQLDMORole_db_accessadmin 128 Reserved.
SQLDMORole_db_backupoperator 4096 Reserved.
SQLDMORole_db_datareader 256 Reserved.
SQLDMORole_db_datawriter 32768 Reserved.
SQLDMORole_db_ddladmin 512 Reserved.
SQLDMORole_db_denydatareader 1024 Reserved.
SQLDMORole_db_denydatawriter 2048 Reserved.
SQLDMORole_db_owner 8192 Reserved.
SQLDMORole_db_None 0 Reserved.
SQLDMORole_db_securityadmin 16384 Reserved.

Server Roles
Constant Value Description
SQLDMORole_dbcreator 1 Reserved.
SQLDMORole_diskadmin 2 Reserved.
SQLDMORole_processadmin 4 Reserved.
SQLDMORole_securityadmin 8 Reserved.
SQLDMORole_serveradmin 16 Reserved.
SQLDMORole_setupadmin 32 Reserved.
SQLDMORole_sysadmin 64 Reserved.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.