How do I show other users' emails in my app? auth.users isn't accessible

auth.users is deliberately not reachable from the API. The usual pattern is a profiles table in public that you fill with a trigger on signup, and only copy what the app needs:

create table public.profiles (
  id uuid primary key references auth.users on delete cascade,
  email text,
  display_name text
);

Then an RLS policy so people only see profiles of members in their own team (not everyone). For existing users, backfill once with insert into public.profiles (id, email) select id, email from auth.users;.

Keep in mind the copy won't follow email changes unless you also add an update trigger.

Also ask yourself if members really need to see each other's email. Display name plus "message" button is often enough, and it's one less thing to leak.

Great question! Accessing user emails in Supabase can be tricky. Here are several approaches you can consider:

1. Use the Admin API: You can use supabase.auth.admin.listUsers() to fetch all users including their emails.
2. Create a view: You can create a view that exposes auth.users to the public schema.
3. Use the service role key: Initialize your client with the service role key to bypass restrictions.

Each approach has its pros and cons depending on your use case. I hope this helps! Let me know if you have any other questions.