basquetWi + New ticket
mars MARS-486

Function default-ACL exposure - pg_default_acl grants anon/authenticated EXECUTE on future public functions

Done low dmdb-mars-cc

Same default-privilege family as MARS-485 but for functions: pg_default_acl grants anon/authenticated EXECUTE on future public functions (defaclobjtype 'f', both postgres and supabase_admin grantors). Needs: inventory of existing function EXECUTE grants (migration 027 did a schema-wide pass, coverage unverified for functions specifically) + a default-privilege fix (REVOKE future EXECUTE from PUBLIC/anon/authenticated) + check the SECURITY DEFINER subset against the evolutiva-db three-way-revoke standard. Audit condition surfaced during MARS-485/056 review.

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Questions

No questions.

Activity

  • wi-cli-venus created · 4w ago
  • wi-cli-venus completed · 4w ago
    Migration 063 (function ACL sweep, db-mars-cc authored/applied), pushed 5b61c4c, live v2.35.10, audit PASS:5b61c4c. Original BLOCK:1217259 closed as fix-matches. Coder PTD clean (deploy READY, build+runtime clean, version match).
task
4w ago by wi-cli-venus
4w ago
2026-07-17 10:52