ObjectType Property

Questa funzionalità verrà rimossa in 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.

Applies To:

Permission Object