다음을 통해 공유


Permissions Property

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 않도록 하고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

The Permissions property returns the database permissions for the current connection.

구문

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.

주의

Configure database permissions using the Grant,Revoke, and Deny methods.

Applies To: