Creating roles on supabase and use direct connection
RLS🔢DB ConnectionsHi community, I enabled RLS for my table and created a role called test_role on the supabase console. i realized that when i tried direct connection (ipv6) and session pooler (ipv4) approaches, i couldn't connect to my database when i changed the user to test_role. on the session pooler, i would think it's the role name with a unique id of the project postpended and separated by a "."
i also added a policy "Enable read access for all users" which defaults to all public roles
any advice here will be great.
i also added a policy "Enable read access for all users" which defaults to all public roles
any advice here will be great.
