However, this example does not work obviously because the table name isnt specified. I read through the docs and cant find a proper example on where to enforce this policy? Is it the auth.users table?
I tried using this:
create policy "Enforce MFA for all users - new and existing" on auth.users as restrictive to authenticated using (auth.jwt()->>'aal' = 'aal2');
create policy "Enforce MFA for all users - new and existing" on auth.users as restrictive to authenticated using (auth.jwt()->>'aal' = 'aal2');
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.