Privilege constants define access rights and permissions within databases and for database objects.
| Constant | Value | Description |
|---|---|---|
| SQLDMOPriv_AllDatabasePrivs | 130944 | All database permissions |
| SQLDMOPriv_AllObjectPrivs | 63 | All applicable object permissions |
| SQLDMOPriv_CreateDatabase | 256 | Can create and own databases |
| SQLDMOPriv_CreateDefault | 4096 | Can create DEFAULT objects |
| SQLDMOPriv_CreateFunction | 65366 | Can create and own UserDefinedFunction objects |
| SQLDMOPriv_CreateProcedure | 1024 | Can create and own StoredProcedure objects |
| SQLDMOPriv_CreateRule | 16384 | Can create rules |
| SQLDMOPriv_CreateTable | 128 | Can create and own base tables |
| SQLDMOPriv_CreateView | 512 | Can create and own view tables |
| SQLDMOPriv_Delete | 8 | Can delete rows in a referenced table |
| SQLDMOPriv_DumpDatabase | 2048 | Can back up a database |
| SQLDMOPriv_DumpTable | 32768 | Can back up a referenced table |
| SQLDMOPriv_DumpTransaction | 8192 | Can back up a database transaction log |
| SQLDMOPriv_Execute | 16 | Can execute a referenced stored procedure |
| SQLDMOPriv_Insert | 2 | Can add rows to a referenced table |
| SQLDMOPriv_References | 32 | Can grant DRI on a referenced table |
| SQLDMOPriv_Select | 1 | Can query a referenced table |
| SQLDMOPriv_Unknown | 0 | No privilege assigned or unable to determine privilege on the referenced database or database object |
| SQLDMOPriv_Update | 4 | Can change row data in a referenced table |
Deny Method (UserDefinedFunction)
Grant Method (StoredProcedure, UserDefinedFunction)
ListDatabasePermissions Method