Database User Profile Constants (SQLDMO_DBUSERPROFILE_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.
Database user profile constants specify permission for a Microsoft® SQL Server™ login or database user used by a client connection.
Constant |
Value |
Description |
|---|---|---|
SQLDMODbUserProf_AllProfileBits |
1023 |
The user has all specifiable database maintenance permissions. |
SQLDMODbUserProf_CreateDefault |
32 |
The user has permission to run the CREATE DEFAULT statement. |
SQLDMODbUserProf_CreateFunction |
512 |
The user has permission to run the CREATE FUNCTION statement. |
SQLDMODbUserProf_/CreateProcedure |
8 |
The user has permission to run the CREATE PROCEDURE statement. |
SQLDMODbUserProf_CreateRule |
128 |
The user has permission to run the CREATE RULE statement. |
SQLDMODbUserProf_CreateTable |
2 |
The user has permission to run the CREATE TABLE statement. |
SQLDMODbUserProf_CreateView |
4 |
The user has permission to run the CREATE VIEW statement. |
SQLDMODbUserProf_/DbNotAvailable |
-1073741824 |
The user's permission level cannot be determined, due to offline or other error. |
SQLDMODbUserProf_DboLogin |
1 |
The user is a member of the db_owner role. |
SQLDMODbUserProf_DumpDatabase |
16 |
The user can back up data for the referenced database. |
SQLDMODbUserProf_DumpTransaction |
64 |
The user can back up the transaction log of the referenced database. |
SQLDMODbUserProf_DumpTable |
256 |
The user can back up database data, specifying a table as the backup unit. |
SQLDMODbUserProf_InaccessibleDb |
-2147483648 |
The referenced database is offline or is otherwise inaccessible. |
SQLDMODbUserProf_InvalidLogin |
1073741824 |
The current connection login does not have user permissions in the referenced database. |
SQLDMODbUserProf_None |
0 |
The user does not have database modification or maintenance permissions. |