SQL-DMO
ObjectType Property
The ObjectType property returns an enumerated value that specifies the type of Microsoft® SQL Server™ 2000 component referenced by a Permission object.
Applies To
Permission Object |
Syntax
object.ObjectType
Parts
object
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-DMO object type constants. Access permission can be granted on SQL Server databases and some database objects. The value returned will be one of these SQLDMO_OBJECT_TYPE values.
Constant | Value | Description |
---|---|---|
SQLDMOObj_Database | 135168 | Permission granted on a SQL Server database. |
SQLDMOObj_StoredProcedure | 16 | Permission granted on a SQL Server stored procedure. |
SQLDMOObj_SystemTable | 2 | Permission granted on a SQL Server system table. |
SQLDMOObj_UserTable | 8 | Permission granted on a SQL Server user-defined table. |
SQLDMOObj_View | 4 | Permission granted on a SQL Server view. |