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.
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.