Handle Supabase Roles

handle_supabase_roles.md

Handle Supabase Roles

Add admin role to user

UPDATE auth.users
SET raw_app_meta_data = raw_app_meta_data || '{"role": "admin"}'::jsonb
WHERE email = 'user@mail.com';

Set email for specific user

UPDATE auth.users
SET raw_user_meta_data = raw_user_meta_data || '{"email": "user@mail.com"}'::jsonb
WHERE email = 'user@mail.com'

Update email confirmation activation

UPDATE auth.users
SET email_confirmed_at = now()
WHERE email IN ('user-one@mail.com', 'user-two@mail.com');