Supabase RLS accessing user's email.
So I have a table with user profiles that contains basic user data like username, email, uid, etc. Now I have RLS enabled for this table to allow only user's profile to be edited. The thing is I want to get access to user's email from
SELECT only if it's his profile. Anybody know how can I do that by RLS Policy?