Upstream information
Description
The fix for CVE-2026-12045 in pgAdmin 4 9.16 required the LLM-supplied query passed to the AI Assistant's execute_sql_query tool to parse, via sqlparse, as exactly one non-transaction-control statement before running it inside a BEGIN TRANSACTION READ ONLY wrapper. sqlparse's string-literal lexing can disagree with PostgreSQL's own parser: under standard_conforming_strings = on (PostgreSQL's default since 9.1), a backslash immediately before a quote is an ordinary character to PostgreSQL, but sqlparse treats it as escaping the quote. A payload such as SELECT '\';COMMIT;CREATE TABLE pwn(x int);SELECT 1 --' therefore parses as a single SELECT to sqlparse's validator, while PostgreSQL executes it as four statements: the smuggled COMMIT ends the wrapping read-only transaction, and the trailing ROLLBACK becomes a no-op. This reintroduces the same write/RCE bypass CVE-2026-12045 was meant to close, reachable via the same indirect prompt-injection delivery (an attacker plants the payload in any object the AI Assistant may read; the LLM emits it as a tool call).An initial candidate fix ran the query with psycopg's execute(..., prepare=True), intending to force PostgreSQL's own Parse step (extended query protocol) to reject multi-statement text regardless of sqlparse's classification. This candidate fix does not work as submitted: psycopg3's PrepareManager silently ignores the prepare argument whenever the connection's prepare_threshold is None, which is pgAdmin's default for every server connection (the per-server "Prepare threshold" field is blank unless an administrator explicitly sets it) -- psycopg3 falls back to the simple query protocol, the same multi-statement-capable path the bypass exploits, so the candidate fix closes nothing on any real-world default configuration.
The corrected fix sets conn.prepare_threshold = 0 directly on the dedicated, single-use read-only connection the AI Assistant tool opens, structurally forcing the extended query protocol independent of any server-level configuration. Verified against a live PostgreSQL 18 instance: the payload executes successfully under the prepare_threshold=None (default) behavior, and is rejected with "cannot insert multiple commands into a prepared statement" once prepare_threshold=0 is set on that connection.
This issue affects pgAdmin 4: from 9.13 before 9.17.
Other Security Trackers
SUSE information
Overall state of this security issue: Resolved
This issue is currently rated as having critical severity.
| CVSS detail | CNA (PostgreSQL) | National Vulnerability Database | SUSE |
|---|---|---|---|
| Base Score | 9 | 9 | 9 |
| Vector | CVSS:3.1/AV:N/AC:L/PR:L/UI:R/S:C/C:H/I:H/A:H | CVSS:3.1/AV:N/AC:L/PR:L/UI:R/S:C/C:H/I:H/A:H | CVSS:3.1/AV:N/AC:L/PR:L/UI:R/S:C/C:H/I:H/A:H |
| Attack Vector | Network | Network | Network |
| Attack Complexity | Low | Low | Low |
| Privileges Required | Low | Low | Low |
| User Interaction | Required | Required | Required |
| Scope | Changed | Changed | Changed |
| Confidentiality Impact | High | High | High |
| Integrity Impact | High | High | High |
| Availability Impact | High | High | High |
| CVSSv3 Version | 3.1 | 3.1 | 3.1 |
| CVSS detail | CNA (PostgreSQL) | SUSE |
|---|---|---|
| Base Score | 9.4 | 9.4 |
| Vector | CVSS:4.0/AV:N/AC:L/AT:N/PR:L/UI:P/VC:H/VI:H/VA:H/SC:H/SI:H/SA:H/E:X/CR:X/IR:X/AR:X/MAV:X/MAC:X/MAT:X/MPR:X/MUI:X/MVC:X/MVI:X/MVA:X/MSC:X/MSI:X/MSA:X/S:X/AU:X/R:X/V:X/RE:X/U:X | CVSS:4.0/AV:N/AC:L/AT:N/PR:L/UI:P/VC:H/VI:H/VA:H/SC:H/SI:H/SA:H |
| Attack Vector | Network | Network |
| Attack Complexity | Low | Low |
| Attack Requirements | None | None |
| Privileges Required | Low | Low |
| User Interaction | Passive | Passive |
| Vulnerable System Confidentiality Impact | High | High |
| Vulnerable System Integrity Impact | High | High |
| Vulnerable System Availability Impact | High | High |
| Subsequent System Confidentiality Impact | High | High |
| Subsequent System Integrity Impact | High | High |
| Subsequent System Availability Impact | High | High |
| CVSSv4 Version | 4.0 | 4.0 |
Status of this issue by product and package
Please note that this evaluation state might be work in progress, incomplete or outdated. Also information for service packs in the LTSS phase is only included for issues meeting the LTSS criteria. If in doubt, feel free to contact us for clarification. The updates are grouped by state of their lifecycle. SUSE product lifecycles are documented on the lifecycle page.
| Product(s) | Source package | State |
|---|---|---|
| Products under general support and receiving all security fixes. | ||
| SUSE Linux Enterprise Desktop 15 SP7 | pgadmin4 | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP7 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Module for Python 3 15 SP7 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server 15 SP7 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server for SAP Applications 15 SP7 | pgadmin4 | Not affected |
| Products under Long Term Service Pack support and receiving important and critical security fixes. | ||
| SUSE Linux Enterprise High Performance Computing 15 SP4 | pgadmin4 | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP4-LTSS | pgadmin4 | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP5 | pgadmin4 | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP5-LTSS | pgadmin4 | Not affected |
| SUSE Linux Enterprise Module for Python 3 15 SP6 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Module for Server Applications 15 SP4 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Module for Server Applications 15 SP5 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server 15 SP4 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server 15 SP4-LTSS | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server 15 SP5 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server 15 SP5-LTSS | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server 15 SP6 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server 15 SP6-LTSS | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server for SAP Applications 15 SP6 | pgadmin4 | Not affected |
| SUSE Manager Proxy 4.3 | pgadmin4 | Not affected |
| SUSE Manager Proxy LTS 4.3 | pgadmin4 | Not affected |
| SUSE Manager Retail Branch Server 4.3 | pgadmin4 | Not affected |
| SUSE Manager Retail Branch Server LTS 4.3 | pgadmin4 | Not affected |
| SUSE Manager Server 4.3 | pgadmin4 | Not affected |
| SUSE Manager Server LTS 4.3 | pgadmin4 | Not affected |
| Products past their end of life and not receiving proactive updates anymore. | ||
| SUSE CaaS Platform 4.0 | pgadmin4 | Not affected |
| SUSE Enterprise Storage 6 | pgadmin4 | Not affected |
| SUSE Enterprise Storage 7 | pgadmin4 | Not affected |
| SUSE Enterprise Storage 7.1 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Desktop 15 SP6 | pgadmin4 | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP1 | pgadmin4 | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP1-ESPOS | pgadmin4 | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP1-LTSS | pgadmin4 | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP2 | pgadmin4 | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP2-ESPOS | pgadmin4 | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP2-LTSS | pgadmin4 | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP3 | pgadmin4 | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP3-ESPOS | pgadmin4 | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP3-LTSS | pgadmin4 | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP4-ESPOS | pgadmin4 | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP5-ESPOS | pgadmin4 | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP6 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Module for Server Applications 15 SP1 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Module for Server Applications 15 SP2 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Module for Server Applications 15 SP3 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Real Time 15 SP2 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Real Time 15 SP3 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Real Time 15 SP4 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server 15 SP1 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server 15 SP1-BCL | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server 15 SP1-LTSS | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server 15 SP2 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server 15 SP2-BCL | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server 15 SP2-LTSS | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server 15 SP3 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server 15 SP3-BCL | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server 15 SP3-LTSS | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server for SAP Applications 15 SP1 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server for SAP Applications 15 SP2 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server for SAP Applications 15 SP3 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server for SAP Applications 15 SP4 | pgadmin4 | Not affected |
| SUSE Linux Enterprise Server for SAP Applications 15 SP5 | pgadmin4 | Not affected |
| SUSE Manager Proxy 4.0 | pgadmin4 | Not affected |
| SUSE Manager Proxy 4.1 | pgadmin4 | Not affected |
| SUSE Manager Proxy 4.2 | pgadmin4 | Not affected |
| SUSE Manager Retail Branch Server 4.0 | pgadmin4 | Not affected |
| SUSE Manager Retail Branch Server 4.1 | pgadmin4 | Not affected |
| SUSE Manager Retail Branch Server 4.2 | pgadmin4 | Not affected |
| SUSE Manager Server 4.0 | pgadmin4 | Not affected |
| SUSE Manager Server 4.1 | pgadmin4 | Not affected |
| SUSE Manager Server 4.2 | pgadmin4 | Not affected |
| openSUSE Leap 15.3 | pgadmin4 | Not affected |
| openSUSE Leap 15.4 | pgadmin4 | Not affected |
| openSUSE Leap 15.5 | pgadmin4 | Not affected |
| openSUSE Leap 15.6 | pgadmin4 | Not affected |
SUSE Timeline for this CVE
CVE page created: Mon Aug 3 13:26:10 2026CVE page last modified: Thu Aug 6 11:33:15 2026