- Added a `SECURITY DEFINER` function `get_is_admin(user_id)` to securely check admin status without triggering RLS recursively. - Updated all "Admins can ...
-- Fix infinite recursion: room_members policy was querying room_members again. -- Use a SECURITY DEFINER function so the membership check bypasses RLS. create or replace function ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results