Artículo
09/29/2010

Permissions Property

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.