Nota
L'accés a aquesta pàgina requereix autorització. Podeu provar d'iniciar la sessió o de canviar els directoris.
L'accés a aquesta pàgina requereix autorització. Podeu provar de canviar els directoris.
Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.
The Permissions property returns the database permissions for the current connection.
Sintaxis
object
.Permissions
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 GetPermissions(SQLDMO_PRIVILEGE_TYPE* pRetVal);
Returns
The return value is a bit-packed long integer, 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. |
Notas
Configure database permissions using the Grant, Revoke, and Deny methods.
Applies To:
Vea también
Referencia
Deny Method (Database)
Grant Method (Database)
Revoke Method (Database)