Horizon Alert
Summary of the vulnerability and why it matters
A critical vulnerability in the Twenty CRM software allows authenticated users to execute arbitrary operating system commands on the database server. This occurs through a combined SQL injection and PostgreSQL attack vector, potentially impacting systems where the PostgreSQL user has superuser privileges and the CRM is accessible externally. The main concern is confirming relevance and exposure.
- Unsanitized input allows command execution.
- CRM accessible externally; high impact possible.
- Verify if this CRM is in use.
Attack Path
How an attacker could exploit the issue
An attacker can exploit this vulnerability by sending a specially crafted request to the CRM's REST API. This request targets the `groupBy` endpoint, specifically manipulating the `timeZone` parameter. If the PostgreSQL user has superuser privileges, this manipulation can lead to the execution of arbitrary operating system commands on the database server.
- Entry Condition: Authenticated user access to the CRM.
- Trigger Point: `timeZone` parameter in `groupBy` endpoint.
- Resulting Risk: Arbitrary OS command execution on the server.
Live Threat
Current exploitation, exposure, and threat context
This vulnerability could allow an authenticated user to execute arbitrary operating system commands on the database server when the PostgreSQL user has superuser privileges. This could occur through the REST API's `groupBy` endpoint by injecting SQL via the `timeZone` parameter, which is directly interpolated into a raw SQL expression.
- Database server OS commands.
- Via unsanitized API parameter.
- Potential for widespread system compromise.
Operational Fix
Recommended remediation, mitigation, and detection steps
Given the critical nature of this vulnerability, application owners are primarily responsible for its remediation, with support from infrastructure and security teams. The immediate first step is to identify all instances of the affected CRM, assess their exposure and business criticality, and then coordinate a response with the vendor and internal teams.
- Application owners must lead the remediation effort.
- Verify CRM reachability and business impact.
- Plan coordinated patching or vendor engagement.