SkillPedia Skills Encyclopedia
中文 EN

Skills 2026-09-30 14:16 UTC

launchworthy

Committed by Wunderlandmedia. Update Category: Bug Fixes & Stability Improvements. Commit details: fix the Supabase view recipe in the over-exposure playbook. This update resolves known runtime errors and enhances system reliability.

Wunderlandmedia 20ded5e Wunderlandmedia/launchworthy

CommitRaw commit message

fix the Supabase view recipe in the over-exposure playbook

Step 4 set security_invoker on the public view and then revoked all table
access from anon and authenticated. An invoker view runs as the caller, so
every read through it failed with permission denied, and Step 8 offered
this as a safe fix.

The new recipe revokes only table-wide select, grants select on the public
columns, and keeps the invoker view over them. Tested against Postgres 16
(PGlite) with anon and authenticated roles: the old recipe fails exactly
as described; the new one returns only the public columns and only the rows
the policy allows (including a policy on a private column), refuses select
* on the table, and leaves the owner's update working.

- fixes/api-over-exposure.md: Step 4 rewritten, with what the change means
  for the app (named columns, writes that return rows, reading your own
  private fields on the server) and the pairing to avoid; Verify updated.
- checklist.md (Domain 2): the Supabase over-exposure bullet describes the
  working pattern.
- plugin.json: 1.1.3.