Share via


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: