Run these in order in Supabase → SQL Editor. After that:

• Create a dispatcher via your Admin page (it stores dispatcher_id lowercase).
• Create an order as a customer with that dsp-#### ID.
• Public tracking works via the /track page using the RPC.

If anything errors, paste the exact error and I’ll fix it immediately.

To configure the generation, complete these steps:

How to apply

• In Supabase → SQL Editor, run scripts/sql/03a_fix_user_profiles_admin_policy.sql.
• Retry creating/updating a profile (e.g., Complete Profile page). It should work without the recursion error.

Why this works

• Policies that query the same table can re-trigger their own policies, causing recursion. Moving the authorization logic into a SECURITY DEFINER function prevents RLS from recursing while still enforcing least-privilege. 12

If you still hit an error, paste the exact error text and I’ll patch it immediately.

Suggested Actions

To configure the generation, complete these steps: