auth schema corrupted?!
After a db reset and faulty recovery, my auth schema is corrupted. The postgres user lost membership in supabase_auth_admin, and core auth functions lost their SECURITY DEFINER property. All attempts to run GRANT are blocked by the pgrst_ddl_watch event trigger, raising a 'reserved role' error. The fix being considered is to temporarily disable this trigger to restore the permissions. Thoughts or input welcome.
Note: I am a complete novice who is being guided by Gemini so please be kind if any of this sounds off.
Note: I am a complete novice who is being guided by Gemini so please be kind if any of this sounds off.
