ObjectType Property

  • Article

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 ObjectType property returns an enumerated value that specifies the type of Microsoft SQL Server component referenced by a Permission object.

Syntax

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