How to assign Superbase User Roles when signing-up


I’m using Superbase Auth in my project and used this Guide to setup everything.

I was able to create Users from Sign-up, But Now my problem is How Do I set the User Roles using this sign-up submit action.

When I try to update the Joining table of Users & Roles, getting bellow error

Screenshot 2024-01-11 at 13.31.14

Thanks in advanced

your issue is to do with row level security or RLS for the tables involved you will need to go to authentication, policies and then add then add a policy to allow inserting.

1 Like

What are the policies on your userRoles table.