Measured: 2026-11-22T15:36:22.332Z · localbase (PGlite, Postgres 18) with after/supabase/migrations and demoSeed(), called with the public anon key and signed-in users' tokens, exactly as the before app's exploits did.
F-01: Anon key reads invoices
http
GET /rest/v1/invoices?select=*&order=total_cents.desc
apikey: $ANONjson
HTTP 401
{"code":"42501","message":"permission denied for table invoices","details":null,"hint":null}F-01: Anon key reads clients (contact emails)
http
GET /rest/v1/clients?select=name,contact_email
apikey: $ANONjson
HTTP 401
{"code":"42501","message":"permission denied for table clients","details":null,"hint":null}F-03: Priya sets her invoice to paid and its total to 1 cent
http
PATCH /rest/v1/invoices?id=eq.4023ce2e-0693-4148-8356-78fadbbf7872&select=id,status,total_cents
Authorization: Bearer $JWT_PRIYA
{"status":"paid","total_cents":1,"paid_at":"2026-11-22T15:36:22.203Z"}json
HTTP 200
[]F-06: A stranger who signed up reads profiles
http
GET /rest/v1/profiles?select=id,full_name
Authorization: Bearer $JWT_STRANGERjson
HTTP 200
[{"id":"33aef54e-eace-4cac-b99b-736af521c66e","full_name":"Stranger"}]F-06: The stranger reads organizations and memberships
http
GET /rest/v1/memberships?select=org_id,role
Authorization: Bearer $JWT_STRANGERjson
HTTP 200
[]F-08: Priya writes role=admin into her own user_metadata (allowed, as in Supabase)
http
PUT /auth/v1/user
{"data":{"role":"admin"}}json
HTTP 200
{"id":"145a74b3-49d5-4f35-99c5-963f9af0a6b5","aud":"authenticated","role":"authenticated","email":"priya@…","email_confirmed_at":"2026-11-22T15:36:21.859Z","confirmed_at":"2026-11-22T15:36:21.859Z","phone":"","last_sign_in_at":"2026-11-22T15:36:22.199Z","app_metadata":{"provider":"email","providers":["email"]},"user_metadata":{"role":"admin","full_name":"Priya Raman"},"identiti ...F-08: With the refreshed token (now carrying role=admin), she reads Tidewater's projects
http
GET /rest/v1/projects?org_id=eq.396a94a8-a43a-4289-91fd-087b55f18d50&select=name
Authorization: Bearer $JWT_PRIYA_ADMINjson
HTTP 200
[]F-09: Anon calls the old revenue function
http
POST /rest/v1/rpc/get_org_revenue
apikey: $ANON
{"org":"396a94a8-a43a-4289-91fd-087b55f18d50"}json
HTTP 404
{"code":"PGRST202","message":"Could not find the function public.get_org_revenue in the schema cache","details":null,"hint":null}F-09: Anon calls the new dashboard function for Tidewater
http
POST /rest/v1/rpc/invoice_summary
apikey: $ANON
{"p_org":"396a94a8-a43a-4289-91fd-087b55f18d50"}json
HTTP 401
{"code":"42501","message":"permission denied for function invoice_summary","details":null,"hint":null}F-09: Priya (Northlake client) calls it for Tidewater
http
POST /rest/v1/rpc/invoice_summary
Authorization: Bearer $JWT_PRIYA
{"p_org":"396a94a8-a43a-4289-91fd-087b55f18d50"}json
HTTP 200
[]F-10: Anon reads the team directory view
http
GET /rest/v1/team_directory?select=*
apikey: $ANONjson
HTTP 404
{"code":"PGRST205","message":"Could not find the table 'public.team_directory' in the schema cache","details":null,"hint":null}F-10: Anon reads memberships
http
GET /rest/v1/memberships?select=*
apikey: $ANONjson
HTTP 401
{"code":"42501","message":"permission denied for table memberships","details":null,"hint":null}