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 privilege |
| 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 privilege |
| SQLDMOSrvUserProf_SaLogin | 1 | Login is a member of the sysadmin role |
| Database User Profile Constants (SQLDMO_DBUSERPROFILE_TYPE) | UserProfile Property |