ObjectType Property
Questa caratteristica verrà rimossa a partire da una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.
The ObjectType property returns an enumerated value that specifies the type of Microsoft SQL Server component referenced by a Permission object.
Sintassi
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. |