PrivilegeType Property
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.
The PrivilegeType property returns the permissions granted to an authorized user or role on a specific database or database object.
Syntax
object
.PrivilegeType
Parts
- object
An expression that evaluates to an object in the Applies To list.
Data Type
Long, enumerated
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetPrivilegeType(SQLDMO_PRIVILEGE_TYPE* pRetVal);
Returns
The PrivilegeType property is interpreted using this information.
| Constant | Value | Description |
|---|---|---|
SQLDMOPriv_AllDatabasePrivs |
130944 |
Has all database permissions. |
SQLDMOPriv_AllObjectPrivs |
63 |
Has 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 (declarative referential integrity) on a referenced table. |
SQLDMOPriv_Select |
1 |
Can query a referenced table. |
SQLDMOPriv_Unknown |
0 |
Has no permissions granted, or permissions could not be determined on the referenced database or database object. |
SQLDMOPriv_Update |
4 |
Can change row data in a referenced table. |
Remarks
A Permission object uniquely identifies a Microsoft SQL Server database user or role granted a specific access right for a specific database or database object. For any permission object retrieved using a permissions listing method, the PrivilegeType property reports a single, unpacked value.
For example, if a user has SELECT and INSERT access rights on a table, and the ListPermissions method of a Table object referencing that table is called, two Permission objects are returned in the list. For one Permission object, the PrivilegeType property returns SQLDMOPriv_Select. For the other, PrivilegeType returns SQLDMOPriv_Insert.