ObjectType Property
Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.
The ObjectType property returns an enumerated value that specifies the type of Microsoft SQL Server component referenced by a Permission object.
Syntaxe
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. |