ObjectType 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 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. |