Advisory

PYSEC-2026-3073

Also known as: CVE-2026-46645, GHSA-54mc-gghv-4cfj

Summary

SQLAdmin: Authorization Bypass on ajax_lookup

Details

Impact

The ajax_lookup endpoint in application.py bypasses the is_accessible() access control check that all other endpoints enforce.

If a developer restricts model access by overriding is_accessible(), an authenticated user can still query that model's data through the ajax_lookup endpoint — silently bypassing the restriction.

Affected endpoint:

GET /{identity}/ajax/lookup?name=<field>&term=<query>

All other endpoints enforce both checks:

| Endpoint | @login_required | is_accessible() |
|---|---|---|
| list | ✓ | ✓ |
| create | ✓ | ✓ |
| edit | ✓ | ✓ |
| delete | ✓ | ✓ |
| details | ✓ | ✓ |
| export | ✓ | ✓ |
| ajax_lookup (before fix) | ✗ | ✗ |
| ajax_lookup (after fix) | ✓ | ✓ |

Note: before this fix, ajax_lookup also lacked the @login_required decorator — unauthenticated users could query it directly. That was addressed in #1035. This report covers the remaining gap: authenticated but unauthorized users.

Patches

Two changes were made to ajax_lookup:

  1. Replaced the hand-rolled authentication check added in #1035 with the standard @login_required decorator used by all other endpoints.
  2. Added the missing is_accessible(request) check, raising HTTP 403 when it returns False.

Workarounds

None. Developers relying on is_accessible() to restrict model visibility are exposed regardless of what other access controls are in place.

Severity

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

Dates

Published
2026-07-13 15:19 UTC
Modified
2026-07-13 16:33 UTC

Affected packages and fixes

sqladmin

PyPI · All systems

Affected

  • introduced 0, fixed 0.25.1 (ecosystem)

Fixed versions

0.25.1

Fix

  • Fixed version 0.25.1
    pip install --upgrade sqladmin==0.25.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