The Column Privileges property indicates whether access rights are restricted on a column-by-column basis.
object.Properties("Column Privileges")
object
Expression that evaluates to an object in the Applies To list.
One of the following settings:
Value | Description |
---|---|
True | Access rights are restricted on a column-by-column basis. The Update method cannot be called in a query that would specify a column for which the user has no read access rights. |
False | Access rights are not restricted on a column-by-column basis. The Update method can be called for any column in the recordset. |
adBoolean
Read-only
DBPROP_COLUMNRESTRICT
If access is restricted both by row and by column, individual columns of particular rows might have their own stricter access rights, therefore the application might not even be permitted to read such columns. In this case, the column values are returned as NULL. If schema rules prevent a NULL value, the recordset should not count or return any rows that would have this condition.