How do you make a user App Admin

  1. Go to the users table in the supabase dashboard in the Authentication section
  2. Get the user uuid from the user you want to make an admin. It is the last column.
  3. In the supabase SQL editor type the following command
select * from make_user_app_admin(user_id);

For Production

In Supabase production, you should go to the auth hooks section of your project.

  1. Enable auth hooks.
  2. Select custom_access_token_hook function from dropdown

Now, the user who is made admin, should have to logout and login for the changes to take effect.