Upstream information
Description
The per-tool permission system (custom roles / role-based tool permissions, introduced in pgAdmin 4 9.3) did not enforce its permission check consistently. In SERVER mode, pgAdmin 4 gates each tool behind a per-tool Flask-Security permission, but the permission decorator (permissions_required) was applied only to a single "front door" route per tool. Every other backend route and Socket.IO handler in that tool's workflow relied solely on pga_login_required/socket_login_required, which check authentication but not the tool permission.The reporter verified three cases against a test build: (1) a user without tools_query_tool permission received 403 on the protected sqleditor initialization route, but the same session went on to connect the server, initialize the viewdata backend chain, and retrieve real table row content; (2) a user without tools_grant_wizard received 403 on the protected acl route, but the same session still enumerated grantable objects, generated GRANT SQL, and successfully applied it -- confirmed database-side via has_table_privilege(); (3) a user without tools_schema_diff received 403 on the protected panel route, but the same session initialized schema diff, enumerated and connected databases, and obtained real DDL differences via the compare_database Socket.IO handler. The reporter also confirmed a related but distinct issue: a non-owner triggering /misc/workspace/adhoc_connect_server against an administrator-owned shared server caused pgAdmin to persist a new server row still owned by the administrator (user_id/shared unchanged from the source), even though the connection attempt itself reported failure.
During remediation, the same front-door-only permission gap was found to also affect the ERD, PSQL, and Debugger tools, and the Backup, Restore, Maintenance, and Import/Export blueprints, none of which were part of the original report; these were fixed using the same pattern as an extension of the reported defect class.
An authenticated user who had valid pgAdmin login and a stored, working database connection, but had been explicitly denied a specific tool's permission by an administrator, could therefore still drive that tool end-to-end through its other routes and sockets, including obtaining an interactive psql session over the /pty Socket.IO namespace and invoking backup/restore/maintenance/import-export jobs.
Because the bypass only restores access to tools operating over the user's own already-authenticated database connection, it does not grant the user any database privilege they did not already hold; it circumvents pgAdmin's own tool-level access-control policy (an organisational segregation-of-duties control, separate from database-level authorization), letting a user reach a pgAdmin feature an administrator intended to withhold from them, using capabilities their existing database role already permits through other means.
Socket.IO event handlers had no permission-aware equivalent of permissions_required; only socket_login_required existed, checking authentication but not the tool permission.
Fix adds a socket_permissions_required decorator (mirroring permissions_required, honouring the Administrator bypass, reading permissions via has_permission()) and applies it, alongside permissions_required, as the outermost decorator on every backend route and Socket.IO handler for the affected tools. Regression tests assert 403 on every gated route and socket handler for a permission-less user.
This issue affects pgAdmin 4 in SERVER mode: from 9.3 before 9.17.
SUSE information
Overall state of this security issue: Resolved
This issue is currently rated as having moderate severity.
| CVSS detail | CNA (PostgreSQL) | SUSE |
|---|---|---|
| Base Score | 5.4 | 5.4 |
| Vector | CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N | CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N |
| Attack Vector | Network | Network |
| Attack Complexity | Low | Low |
| Privileges Required | Low | Low |
| User Interaction | None | None |
| Scope | Unchanged | Unchanged |
| Confidentiality Impact | Low | Low |
| Integrity Impact | Low | Low |
| Availability Impact | None | None |
| CVSSv3 Version | 3.1 | 3.1 |
| CVSS detail | CNA (PostgreSQL) | SUSE |
|---|---|---|
| Base Score | 5.3 | 5.3 |
| Vector | CVSS:4.0/AV:N/AC:L/AT:N/PR:L/UI:N/VC:L/VI:L/VA:N/SC:N/SI:N/SA:N/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:N/VC:L/VI:L/VA:N/SC:N/SI:N/SA:N |
| Attack Vector | Network | Network |
| Attack Complexity | Low | Low |
| Attack Requirements | None | None |
| Privileges Required | Low | Low |
| User Interaction | None | None |
| Vulnerable System Confidentiality Impact | Low | Low |
| Vulnerable System Integrity Impact | Low | Low |
| Vulnerable System Availability Impact | None | None |
| Subsequent System Confidentiality Impact | None | None |
| Subsequent System Integrity Impact | None | None |
| Subsequent System Availability Impact | None | None |
| 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:09 2026CVE page last modified: Mon Aug 3 15:23:50 2026