The ObjectType property returns an enumerated value specifying the type of Microsoft® SQL Server™ component referenced by a Permission object.
object.ObjectType
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
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 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 |
Long, enumerated
Read-only
HRESULT GetObjectType(SQLDMO_OBJECT_TYPE* pRetVal);