Advisory

PYSEC-2026-3922

Also known as: CVE-2026-54529, GHSA-ccg5-9c8w-xh6v

Summary

SQLAdmin: Unvalidated sortBy parameter in ModelView bypasses column_sortable_list

Details

Summary

ModelView.sort_query() uses the attacker-controlled sortBy list-view query parameter without checking it against the configured column_sortable_list allow-list. The value is resolved with getattr(model, ...) and fed into relationship joins and order_by(), so a request can sort by any column of the model — including ones hidden from column_list — and, via a dotted path, by columns of related models. Because row order then reflects the value of an unexposed column, this is an information-exposure ordering oracle.

Root cause

column_sortable_list is consulted only in the list template to decide which header links to render; the server never enforces it, so removing a column from the UI does not prevent sorting by it.

Exploitation

A single request leaks the relative ordering of an unexposed column; the asc↔desc reversal confirms rows are ordered by the secret's actual value. Pairing sortBy with searchable/filterable columns and pagination can narrow the oracle toward specific values, though value recovery is conditional on having a filterable target column.

Severity

Medium Basis: CVSS v3 score 5.3, vector CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:L/I:N/A:N

Dates

Published
2026-09-10 09:45 UTC
Modified
2026-09-10 12:15 UTC

Affected packages and fixes

sqladmin

PyPI · All systems

Affected

  • introduced 0, fixed 0.27.1 (ecosystem)

Fixed versions

0.27.1

Fix

  • Fixed version 0.27.1
    pip install --upgrade sqladmin==0.27.1

Fix commands are the export's own generic commands. Ojuju never runs them. Check them against your setup first.

Check your own computer: guard packages check

View this record on OSV.dev

Source

Source: PyPA Advisory Database · CC BY 4.0

Sources & licences