MDAC 2.5 SDK - OLE DB Programmer's Reference
Appendix C: OLE DB Properties


 

DBPROP_COLUMNRESTRICT

Property group: Rowset

Property set: DBPROPSET_ROWSET

Column? N

Type: VT_BOOL

Typical R/W: R

Description: Column Privileges

Value Meaning
VARIANT_TRUE Access rights are restricted on a column-by-column basis. If the rowset exposes IRowsetChange, IRowsetChange::SetData cannot be called for at least one column. A provider must not execute a query that would specify a column for which the consumer has no read access rights.
VARIANT_FALSE Access rights are not restricted on a column-by-column basis. If the rowset exposes IRowsetChange, IRowsetChange::SetData can be called for any column in the rowset.

If access is restricted both by row and by column, individual columns of particular rows might have their own stricter access rights; the consumer might not even be permitted to read such columns. The column values will be NULL. If a NULL value is contrary to schema rules (NULLs not permitted), the rowset should not count or return any rows that would have this condition. For more information, see DBPROP_ROWRESTRICT.