The profiles table RLS policies only allowed users to view their own
profile, causing the share feature to fail when searching for users
by email. Added a policy allowing any authenticated user to read profiles.
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>