Permissions Property
Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.
The Permissions property returns the database permissions for the current connection.
Syntax
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. |
Hinweise
Configure database permissions using the Grant,Revoke, and Deny methods.