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. |