Server User Profile Constants (SQLDMO_SRVUSERPROFILE_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.
Server user profile constants specify permissions for a Microsoft SQL Server login or database user used by a client connection.
Constant |
Value |
Description |
|---|---|---|
SQLDMOSrvUserProf_/AllProfileBits |
7 |
The login has all specifiable SQL Server maintenance permissions. |
SQLDMOSrvUserProf_/CreateDatabase |
2 |
The login has permission to execute the CREATE DATABASE statement. |
SQLDMOSrvUserProf_CreateXP |
4 |
The login can execute sp_addextendedproc and sp_dropextendedproc (loading and unloading extended stored procedures). |
SQLDMOSrvUserProf_None |
0 |
The login has no SQL Server maintenance permission. |
SQLDMOSrvUserProf_SaLogin |
1 |
The login is a member of the sysadmin role. |