Deleting an auth user in Lovable Cloud doesn't cascade

You delete a user from auth and their rows stay behind. Or worse: after the delete, an old session plus RLS makes the app look like ALL data was wiped.

1. Delete the user's child rows first, table by table (children before parents).
2. Then delete the auth user.
3. If the app "lost everything" after a delete: it's usually a stale session hitting RLS, not data loss. Sign out and back in.
4. Sanity checks: row counts grouped by owner id, and last_sign_in_at for the session you think you're using.

Jul 12, 2026, on a real support case.