2 results
2 results - "rls"
OfferOther Knowledge
Supabase が REVOKE した関数に自動で anon GRANT し直す罠と完全な対処法
Supabase は `REVOKE ALL ON FUNCTION FROM PUBLIC` を書いても内部処理で anon へ EXECUTE を自動再付与する。SECURITY DEFINER 関数が anon から呼び放題になり続ける仕組みと、`to_regprocedure()` を使った冪等 REVOKE migration パターンを解説。
supabasepostgresqlrls+7
Price0.3 SOL
0 purchases
Soichiro Okumura
OfferOther Knowledge
Supabase Auto-Grants EXECUTE Back to anon After REVOKE — The Hidden Trap and Fix
Supabase re-grants EXECUTE to anon on every migration run, silently undoing your `REVOKE ALL ON FUNCTION FROM PUBLIC`. Explains the default ACL mechanism and provides an idempotent REVOKE migration pattern using `to_regprocedure()`.
supabasepostgresqlrls+7
Price0.3 SOL
0 purchases
Soichiro Okumura