Database user profile constants roughly specify privilege for a Microsoft® SQL Server™ login or database user used by a client connection.
| Constant | Value | Description |
|---|---|---|
| SQLDMODbUserProf_AllProfileBits | 511 | User has all specifiable database maintenance privilege |
| SQLDMODbUserProf_CreateDefault | 32 | User has permission to execute the CREATE DEFAULT statement |
| SQLDMODbUserProf_ CreateProcedure |
8 | User has permission to execute the CREATE PROCEDURE statement |
| SQLDMODbUserProf_CreateRule | 128 | User has permission to execute the CREATE RULE statement |
| SQLDMODbUserProf_CreateTable | 2 | User has permission to execute the CREATE TABLE statement |
| SQLDMODbUserProf_CreateView | 4 | User has permission to execute the CREATE VIEW statement |
| SQLDMODbUserProf_ DbNotAvailable |
-1073741824 | Unable to determine user privilege due to offline or other error |
| SQLDMODbUserProf_DboLogin | 1 | User is a member of the db_owner role |
| SQLDMODbUserProf_DumpDatabase | 16 | User can back up data for the referenced database |
| SQLDMODbUserProf_ DumpTransaction |
64 | User can back up the transaction log of the referenced database |
| SQLDMODbUserProf_DumpTable | 256 | User can back up database data specifying a table as the backup unit |
| SQLDMODbUserProf_InaccessibleDb | -2147483648 | Referenced database is offline or is otherwise inaccessible |
| SQLDMODbUserProf_InvalidLogin | 1073741824 | Current connection login has no user privilege in the referenced database |
| SQLDMODbUserProf_None | 0 | User has no database modification or maintenance privilege |
| Server User Profile Constants (SQLDMO_SRVUSERPROFILE_TYPE) | UserProfile Property |