How do you make a user App Admin
- Go to the
users
table in the supabase dashboard in the Authentication section - Get the user uuid from the user you want to make an admin. It is the last column.
- 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.
- Enable auth hooks.
- 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.