Freigeben über


PrivilegeType 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 PrivilegeType property returns the permissions granted to an authorized user or role on a specific database or database object.

Syntax

object.PrivilegeType

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 GetPrivilegeType(SQLDMO_PRIVILEGE_TYPE* pRetVal);

Returns

The PrivilegeType property is 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

A Permission object uniquely identifies a Microsoft SQL Server database user or role granted a specific access right for a specific database or database object. For any permission object retrieved using a permissions listing method, the PrivilegeType property reports a single, unpacked value.

For example, if a user has SELECT and INSERT access rights on a table, and the ListPermissions method of a Table object referencing that table is called, two Permission objects are returned in the list. For one Permission object, the PrivilegeType property returns SQLDMOPriv_Select. For the other, PrivilegeType returns SQLDMOPriv_Insert.

Applies To: