Implemented features

• Add some restrictions in the sql request:

  • you can only read datas. No update, deletion or creation are possible.
  • some tables are not allowed, because they could contains clear password or keys. For the time being ('ir_config_parameter').

• The request can be in a 'draft' or a 'SQL Valid' status. To be valid, the request has to be cleaned, checked and tested. All of this operations can be disabled in the inherited modules.

• This module two new groups:

  • SQL Request / User : Can see all the sql requests by default and execute them, if they are valid.
  • SQL Request / Manager : has full access on sql requests.

Usage

Inherit the model:

from openerp import models

class MyModel(models.model)

_name = 'my.model' _inherit = ['sql.request.mixin']

_sql_request_groups_relation = 'my_model_groups_rel'

_sql_request_users_relation = 'my_model_users_rel'

Images

• Odoo Community Association: Icon.

Contributors

• Florian da Costa <florian.dacosta@akretion.com>
• Sylvain LE GAL (https://twitter.com/legalsylvain)

Funders

The development of this module has been financially supported by:

• Akretion (<http://www.akretion.com>)
• GRAP, Groupement Régional Alimentaire de Proximité (<http://www.grap.coop>)

Maintainer

This module is maintained by the OCA.

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

To contribute to this module, please visit https://odoo-community.org.