ODBC Driver for Odoo

Build 25.0.9434

CheckPermissions

Specifies whether the provider uses the Odoo user's permissions to determine which tables and views to expose.

Data Type

bool

Default Value

true

Remarks

Odoo users have different levels of access to various models. When this property is set to true, the driver checks model-level permissions to classify objects:

  • Models the user can modify appear as tables.
  • Models the user can only read appear as views.
  • Models the user cannot access are excluded from the schema.

To perform this permissions check, the driver queries the ir.model.access model. However, most users do not have read access to this model by default. If the connecting user lacks access, and administrator-level access cannot be granted, set this property to false.

When this property is set to false, the driver skips the permissions check and lists all models in Odoo as tables, regardless of the user’s actual access level.

Set this property to false only if the connecting user lacks access to ir.model.access.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434