ci(e2e): narrow post-migration service_role grants to match schema.sql

↗ view on GitHub · willchen96 · 2026-07-26 · f3173a9d

schema.sql now grants service_role its own narrowed privileges
(upstream "narrow service role schema grants"), so the broad GRANT ALL
workaround is obsolete - and worse, it widened the test database beyond
what prod gets, letting e2e pass on privileges a real deployment lacks.
Keep a post-migration re-grant (schema.sql's ON ALL statements can't
cover tables the migrations create) but with the identical narrowed set.

Co-Authored-By: Claude Fable 5 <noreply@anthropic.com>
Repository open-legal-products/mike
Author willchen96 <weiye.chen96@icloud.com>
Authored
Parents c196f9b2
Stats 3 files changed , +22 , -21
Part of Add Playwright coverage for critical legal-AI flows

Capture this commit into my fork

Download a Markdown prompt that tells Claude how to port this exact commit into your working tree. Run it via claude -p < capture-commit-f3173a9d.md from inside the repo you want the change in.

⬇ Download capture-commit-f3173a9d.md