ADO and SQL Server
Column Privileges Property
The Column Privileges property indicates whether access rights are restricted on a column-by-column basis.
Applies To
| Command Object | Recordset Object |
Syntax
object.Properties("Column Privileges")
Parts
object
Expression that evaluates to an object in the Applies To list.
Returns
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. |
Data Type
adBoolean
Modifiable
Read-only
OLE DB Property
DBPROP_COLUMNRESTRICT
Remarks
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.