ADO and SQL Server
Row Privileges Property
The Row Privileges property indicates whether access rights are restricted on a row-by-row basis.
Applies To
| Command Object | Recordset Object |
Syntax
object.Properties("Row Privileges")
Parts
object
Expression that evaluates to an object in the Applies To list.
Returns
One of the following values:
| Value | Description |
|---|---|
| True | Access rights are restricted on a row-by-row basis. If the recordset supports the OLE DB IRowsetChange interface, the ADO Update method can be called for some but not all rows. A recordset must never count or return a handle for a row for which the application does not have read access rights. |
| False | Access rights are not restricted on a row-by-row basis. If the recordset supports the OLE DB IRowsetChange interface, the ADO Update method can be called for any row. |
Data Type
adBoolean
Modifiable
Read-only
OLE DB Property
DBPROP_ROWRESTRICT