{"id":"GHSA-6wqw-vhfr-9999","title":"SurrealDB: Authenticated subscribers can read records hidden by SELECT permissions via LIVE subscriptions","summary":"SurrealDB: Authenticated subscribers can read records hidden by SELECT permissions via LIVE subscriptions","severity":"medium","cvss":4.3,"cwe":["CWE-863"],"vendor":"surrealdb","product":"surrealdb","ecosystem":"rust","affected":["surrealdb < 3.1.0"],"patched":["surrealdb 3.1.0"],"published":"2026-07-01","updated":"2026-07-01","source":"GHSA","sourceUrl":"https://github.com/advisories/GHSA-6wqw-vhfr-9999","references":[{"url":"https://github.com/surrealdb/surrealdb/security/advisories/GHSA-6wqw-vhfr-9999"},{"url":"https://github.com/surrealdb/surrealdb/commit/6bcc55c9c0494a0d4d36821019b54459f7162af7"},{"url":"https://github.com/orgs/surrealdb/discussions/101"},{"url":"https://github.com/advisories/GHSA-6wqw-vhfr-9999"}],"tags":["ghsa","rust"],"ingestedAt":"2026-07-01T21:17:11.625Z","slug":"GHSA-6wqw-vhfr-9999","body":"## Overview\n\nA record user could read records the table's SELECT permission expression should have hidden, when that expression referenced `$value`, `$before`, `$after`, or `$event`. Binding a chosen value to that name before registering a `LIVE SELECT` caused notifications to evaluate the permission against the attacker's input instead of the real document.\n\n### Impact\n\nA record user binds a value to `$value`, `$before`, `$after`, or `$event` (e.g. `LET $value = [$auth.id]`) and registers `LIVE SELECT * FROM person`. The captured value shadows the real document at notification time, so a SELECT permission like `WHERE $auth.id.id() IN $value` passes for every record on the table — the subscriber receives notifications for records they should not see.\n\nRead-only impact, bounded to one table. Permission expressions that reference only field names, `$auth`, or `$session` are unaffected.\n\n### Patches\n\nA patch has been introduced that re-orders the LIVE notification parameter binding so captured user variables are added first and the trusted document-context and session parameters are added last.\n\n- Versions 3.1.0 and later are not affected by this issue.\n\n### Workarounds\n\nAffected users who are unable to update should avoid table-`PERMISSIONS` and LIVE `WHERE` expressions that read user-named variables (`$value`, `$before`, `$after`, `$event`) without also gating on a system-derived field such as the record id.\n\n## Affected packages\n\n- `surrealdb < 3.1.0`\n\n## Remediation\n\nUpgrade to a patched release:\n\n- `surrealdb 3.1.0`","depth":"sunlit","depthScore":24,"depthScoreParts":{"impact":23.7,"likelihood":0,"exploitation":0,"ransomware":0},"changes":[]}