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.

Table of contents

from odoo 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'

Authors

• GRAP
• Akretion

Contributors

• Florian da Costa <[email protected]>
• Sylvain LE GAL (https://twitter.com/legalsylvain)
• Alfadil Tabar ([email protected])
• Helly kapatel <[email protected]>

Maintainers

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.

Current maintainer:

This module is part of the OCA/reporting-engine project on GitHub.

You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.