Поделиться через

ObjectType Property

  • Статья

В будущей версии Microsoft SQL Server эта возможность будет удалена. Избегайте использования этой возможности в новых разработках и запланируйте изменение существующих приложений, в которых она применяется.

The ObjectType property returns an enumerated value that specifies the type of Microsoft SQL Server component referenced by a Permission object.

Синтаксис

object
.ObjectType

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 GetObjectType(SQLDMO_OBJECT_TYPE* pRetVal);

Returns

Values returned by the ObjectType property are enumerated by SQL Distributed Management Objects (SQL-DMO) object type constants. Access permission can be granted on SQL Server databases and some database objects. The value returned is one of the following SQLDMO_OBJECT_TYPE values.

Constant Value Description

SQLDMOObj_Database

135168

Permission is granted on a SQL Server database.

SQLDMOObj_StoredProcedure

16

Permission is granted on a SQL Server stored procedure.

SQLDMOObj_SystemTable

2

Permission is granted on a SQL Server system table.

SQLDMOObj_UserTable

8

Permission is granted on a SQL Server user-defined table.

SQLDMOObj_View

4

Permission is granted on a SQL Server view.

Applies To:

Permission Object