Permissions 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 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. |
Remarks
Configure database permissions using the Grant, Revoke, and Deny methods.
Applies To:
See Also
Reference
Deny Method (Database)
Grant Method (Database)
Revoke Method (Database)