Supabase User Management Environment

I would like you to set up a complete, production-ready user management environment powered by Supabase for my web application. The system will serve external customers only, and new accounts will be created through a straightforward email-and-password flow.

Core requirements
• Role-based access control that gates content and features by permission level
• Editable customer profile pages tied to Supabase tables and row-level security (RLS)
• A server-side activity log capturing log-ins, profile edits, and role changes

I have the UX already mapped in Figma, and all tasks are tracked in ClickUp, so familiarity with both tools will keep collaboration smooth.

Deliverables
• Supabase project configured with auth, RLS policies, roles, and structured tables matching the Figma schema
• Front-end or API endpoints for sign-up, sign-in, password reset, role updates, and activity queries
• Clear setup documentation so another developer can spin up the same environment locally

Acceptance criteria
• Email/password sign-up and log-in work end-to-end, including password reset
• Protected routes reject unauthorized roles, verified through RLS tests
• Activity log records at least the three events listed above and is queryable via SQL or API

If you have recent experience with Supabase auth and feel comfortable iterating inside Figma. or Figma Make and ClickUp, this should be a concise, focused build.