{
  "containers": {
    "cna": {
      "affected": [
        {
          "product": "openremote",
          "vendor": "openremote",
          "versions": [
            {
              "status": "affected",
              "version": "\u003c 1.26.0"
            }
          ]
        }
      ],
      "descriptions": [
        {
          "lang": "en",
          "value": "OpenRemote is an open-source internet-of-things platform. Prior to 1.26.0, the `datapoint export` API constructs `CSV crosstab` SQL by concatenating an `asset name` and `attribute name` into a `COPY` query that uses `crosstab` and streams `TO STDOUT`. The `asset name` enters both a double-quoted column identifier and a category query enclosed by the fixed `$cat$` delimiter. Escaping single quotes in one string context does not escape embedded double quotes in identifiers or protect that dollar-quote boundary. An authenticated user permitted to create or rename an asset and read/export datapoints for one of its attributes can store SQL metacharacters in the name and request a `crosstab` export, causing injected SELECT output to be returned in the normal ZIP/CSV response. This enables database exfiltration without direct database or filesystem access or token forgery. In a multi-tenant deployment it can expose other tenants\u0027 data if the manager\u0027s database role can read shared tables; integrity and availability effects are not established by the demonstrated read primitive. This issue is fixed in version 1.26.0."
        }
      ],
      "metrics": [
        {
          "cvssV4_0": {
            "attackComplexity": "LOW",
            "attackRequirements": "NONE",
            "attackVector": "NETWORK",
            "baseScore": 7.2,
            "baseSeverity": "HIGH",
            "privilegesRequired": "LOW",
            "subAvailabilityImpact": "NONE",
            "subConfidentialityImpact": "NONE",
            "subIntegrityImpact": "NONE",
            "userInteraction": "NONE",
            "vectorString": "CVSS:4.0/AV:N/AC:L/AT:N/PR:L/UI:N/VC:H/VI:L/VA:L/SC:N/SI:N/SA:N",
            "version": "4.0",
            "vulnAvailabilityImpact": "LOW",
            "vulnConfidentialityImpact": "HIGH",
            "vulnIntegrityImpact": "LOW"
          }
        }
      ],
      "problemTypes": [
        {
          "descriptions": [
            {
              "cweId": "CWE-89",
              "description": "CWE-89: Improper Neutralization of Special Elements used in an SQL Command (\u0027SQL Injection\u0027)",
              "lang": "en",
              "type": "CWE"
            }
          ]
        }
      ],
      "providerMetadata": {
        "dateUpdated": "2026-10-30T22:05:43.581Z",
        "orgId": "a0819718-46f1-4df5-94e2-005712e83aaa",
        "shortName": "GitHub_M"
      },
      "references": [
        {
          "name": "https://github.com/openremote/core/security/advisories/GHSA-cgfv-jrfp-2r7v",
          "tags": [
            "x_refsource_CONFIRM"
          ],
          "url": "https://github.com/openremote/core/security/advisories/GHSA-cgfv-jrfp-2r7v"
        },
        {
          "name": "https://github.com/openremote/core/commit/02ac83074b81617add814b2a72d459abdf374147",
          "tags": [
            "x_refsource_MISC"
          ],
          "url": "https://github.com/openremote/core/commit/02ac83074b81617add814b2a72d459abdf374147"
        },
        {
          "name": "https://github.com/openremote/core/releases/tag/1.26.0",
          "tags": [
            "x_refsource_MISC"
          ],
          "url": "https://github.com/openremote/core/releases/tag/1.26.0"
        }
      ],
      "source": {
        "advisory": "GHSA-cgfv-jrfp-2r7v",
        "discovery": "UNKNOWN"
      },
      "title": "OpenRemote has authenticated SQL injection in crosstab datapoint exports"
    }
  },
  "cveMetadata": {
    "assignerOrgId": "a0819718-46f1-4df5-94e2-005712e83aaa",
    "assignerShortName": "GitHub_M",
    "cveId": "CVE-2026-63224",
    "datePublished": "2026-10-30T22:05:43.581Z",
    "dateReserved": "2026-07-15T22:19:06.907Z",
    "dateUpdated": "2026-10-30T22:05:43.581Z",
    "state": "PUBLISHED"
  },
  "dataType": "CVE_RECORD",
  "dataVersion": "5.2"
}