Privilege Constants (SQLDMO_PRIVILEGE_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.
Privilege constants define access rights and permissions within databases and for database objects.
Constant |
Value |
Description |
|---|---|---|
SQLDMOPriv_AllDatabasePrivs |
130944 |
All database permissions are granted. |
SQLDMOPriv_AllObjectPrivs |
63 |
All applicable object permissions are granted. |
SQLDMOPriv_CreateDatabase |
256 |
Users can create and own databases. |
SQLDMOPriv_CreateDefault |
4096 |
Users can create DEFAULT objects. |
SQLDMOPriv_CreateFunction |
65366 |
Users can create and own UserDefinedFunction objects. |
SQLDMOPriv_CreateProcedure |
1024 |
Users can create and own StoredProcedure objects. |
SQLDMOPriv_CreateRule |
16384 |
Users can create rules. |
SQLDMOPriv_CreateTable |
128 |
Users can create and own base tables. |
SQLDMOPriv_CreateView |
512 |
Users can create and own view tables. |
SQLDMOPriv_Delete |
8 |
Users can delete rows in a referenced table. |
SQLDMOPriv_DumpDatabase |
2048 |
Users can back up a database. |
SQLDMOPriv_DumpTable |
32768 |
Users can back up a referenced table. |
SQLDMOPriv_DumpTransaction |
8192 |
Users can back up a database transaction log. |
SQLDMOPriv_Execute |
16 |
Users can run a referenced stored procedure. |
SQLDMOPriv_Insert |
2 |
Users can add rows to a referenced table. |
SQLDMOPriv_References |
32 |
Users can grant DRI (Declarative Referential Integrity) on a referenced table. |
SQLDMOPriv_Select |
1 |
Users can query a referenced table. |
SQLDMOPriv_Unknown |
0 |
No permissions are assigned, or permissions on the referenced database or database object could not be determined. |
SQLDMOPriv_Update |
4 |
Can change row data in a referenced table. |
See Also