how to access auth.users table for functions trigger

Question

I need some help with supabase triggers. I am trying to follow along with this tutorial here, however I can't seem to figure out how to access the auth.users table, as it seems to be protected. When I try to create a trigger all I get are the public tables I created in the project. How do I watch the auth users table?

Julia Pak · Accepted Answer · 2024-08-27 03:35:17Z

0

Ok so if you want to create a trigger from the auth.user table you need to go into the SQL editor and run this:

create trigger on_auth_user_added after insert on auth.users for each row execute function handle_new_user();

answered Aug 27, 2024 at 3:35

Julia Pak

7621 gold badge9 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to access auth.users table for functions trigger

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related