SQL-DMO
Server User Profile Constants (SQLDMO_SRVUSERPROFILE_TYPE)
Server user profile constants roughly specify privilege for a Microsoft® SQL Server™ login or database user used by a client connection.
| Constant | Value | Description |
|---|---|---|
| SQLDMOSrvUserProf_AllProfileBits | 7 | Login has all specifiable SQL Server maintenance permissions. |
| SQLDMOSrvUserProf_CreateDatabase | 2 | Login has permission to execute the CREATE DATABASE statement. |
| SQLDMOSrvUserProf_CreateXP | 4 | Login can execute sp_addextendedproc and sp_dropextendedproc (loading and unloading extended stored procedures). |
| SQLDMOSrvUserProf_None | 0 | Login has no SQL Server maintenance permission. |
| SQLDMOSrvUserProf_SaLogin | 1 | Login is a member of the sysadmin role. |