Security RLS policy on users table

I have a users table, with a schema that looks like this:

create table public.users (
  id uuid not null,
  organization_id bigint null,
  approved boolean not null default false,
  admin boolean null default false,
);

create table public.users (
  id uuid not null,
  organization_id bigint null,
  approved boolean not null default false,
  admin boolean null default false,
);

create table public.users (
  id uuid not null,
  organization_id bigint null,
  approved boolean not null default false,
  admin boolean null default false,
);

create table public.users (
  id uuid not null,
  organization_id bigint null,
  approved boolean not null default false,
  admin boolean null default false,
);

Basically, I want to have an auth policy that:
allow users to read users of those within the same organization

Is this achievable with supabase? If so, how? Currently, I have a RLS policy that causes infinate recursion, and I'm not sure how to make one that doesn't

Security RLS policy on users table

Similar Threads

Similar Threads

Similar Threads