ymahmo
02/15/2022, 9:50 PMsilentworks
02/16/2022, 10:07 AMymahmo
02/16/2022, 3:18 PMymahmo
02/16/2022, 3:19 PMCREATE FUNCTION
public.handle_new_user()
RETURNS TRIGGER AS
$$
BEGIN
INSERT INTO public.users (id)
VALUES (NEW.id);
RETURN NEW;
END;
$$ LANGUAGE plpgsql SECURITY DEFINER;
CREATE TRIGGER on_auth_user_created
AFTER INSERT
ON auth.users
FOR EACH ROW
EXECUTE FUNCTION public.handle_new_user();
and here are the policies on my user table:
Public users are viewable by everyone.
true
SELECT
Edit
Delete
Users can insert their own profile.
(uid() = id)
INSERT
Edit
Delete
Users can update own profile.
(uid() = id)ymahmo
02/16/2022, 3:19 PMsilentworks
02/16/2022, 8:53 PM