PrivilegeType Property
Esse recurso será removido em uma versão futura do Microsoft SQL Server. Evite usar esse recurso em desenvolvimentos novos e planeje modificar os aplicativos que atualmente o utilizam.
The PrivilegeType property returns the permissions granted to an authorized user or role on a specific database or database object.
Sintaxe
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. |
Comentários
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.