| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 915 |
| Technical Name |
sql_statement_audit_log |
| License | See License tab |
| Website | https://www.linkedin.com/in/dfunn1k/ |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 915 |
| Technical Name |
sql_statement_audit_log |
| License | See License tab |
| Website | https://www.linkedin.com/in/dfunn1k/ |
SQL Statement Audit Log
Execute SQL from Odoo with guardrails and full traceability
This module allows technical users to create reusable SQL statements, execute them with role-based permissions, and keep a detailed execution history (status, user, duration, row count, and result preview).
Key Features
- Reusable SQL statement catalog
- Execution log with immutable history records
- Server-side HTML rendering for query results
- Fast review of last execution from each statement
- Read-only and limited DML execution modes
- Single-statement validation
- Forbidden keyword/function checks
- Timeout and lock timeout protection
Security Model
Read-only
Can view statement logs and execution history.
Query Executor
Can execute SELECT, EXPLAIN, and SHOW.
Admin
Includes Query Executor and allows limited DML: INSERT, UPDATE, DELETE.
Blocked Operations
For safety, this module blocks DDL statements, privilege and transaction control statements,
and unsafe functions such as pg_sleep() and dblink().
How to Use
- Assign security groups in Settings > Users & Companies > Users.
- Open SQL Statement Audit > Statement Log.
- Create or edit a statement and click Execute.
- Review results and full history in SQL Statement Audit > Executions.
The roles shown in this page are enforced by the module security groups and access rules.
Support: danychavezdev@gmail.com
SOFTWARE LICENSE AGREEMENT ========================== Effective 2026 Copyright (c) 2026 Dany Anderson Chavez Pauca This Software License Agreement (the "Agreement") is made between Dany Anderson Chavez Pauca (the "Licensor") and the purchaser (the "Licensee"). By accepting or using the Software—comprising multiple Odoo modules across various repositories—the Licensee agrees to be bound by the terms set forth below. 1. Grant of License The Licensor grants the Licensee a non-exclusive, non-transferable, revocable license to use the Software solely for Licensee’s internal purposes and for projects developed and maintained directly by Licensee. This Agreement expressly prohibits any form of redistribution, sublicensing, or commercialization of the Software. 2. Permitted Use The Software is sold directly to the Licensee and may only be used within Licensee’s own projects. The Licensee is not permitted to distribute, resell, lease, or otherwise commercialize the Software or any derivatives thereof. Unauthorized distribution or commercialization may result in legal action. 3. Restrictions on Distribution and Commercialization The Licensee shall not distribute, share, or make the Software available to any third party in any form—either as a standalone product or as part of another project. Any breach of this provision will be considered a material violation of this Agreement, subjecting the Licensee to immediate termination of the license and potential legal liability. 4. Ownership and Intellectual Property Rights All rights, title, and interest in and to the Software, including any modifications or improvements, remain the exclusive property of the Licensor. Licensee acknowledges that no title or ownership rights are transferred under this Agreement. 5. Modifications and Maintenance Any modifications, enhancements, or maintenance work on the Software shall only be performed with the prior written consent of the Licensor. Licensee shall not alter any portion of the Software that would permit its resale or redistribution. 6. Warranty Disclaimer and Limitation of Liability The Software is provided "as is," without warranty of any kind, either express or implied, including but not limited to any implied warranties of merchantability, fitness for a particular purpose, or non-infringement. In no event shall the Licensor be liable for any damages (including direct, indirect, incidental, consequential, or punitive damages) arising out of the use or inability to use the Software, even if advised of the possibility of such damages. 7. Indemnification The Licensee agrees to indemnify, defend, and hold harmless the Licensor from any claims, damages, liabilities, costs, or expenses (including reasonable attorneys' fees) arising from Licensee's use of the Software or any breach of this Agreement. 8. Termination This Agreement is effective until terminated. The Licensee's rights under this Agreement will terminate automatically if any term or condition is breached. Upon termination, the Licensee shall immediately cease all use of the Software and destroy all copies in its possession or control. 9. Governing Law This Agreement shall be governed by and construed in accordance with the laws of the applicable jurisdiction, without regard to its conflict of law provisions. 10. Entire Agreement This Agreement constitutes the entire understanding between the parties regarding the Software and supersedes any prior agreements, whether written or oral. By using the Software, the Licensee acknowledges that it has read, understood, and agrees to be bound by the terms and conditions of this Agreement.
Please log in to comment on this module