▣ wi

Disable 107 orphan-auth users (auth huerfanas, never logged in)

Ref

MARS-86 (#863)

Project

mars

Status

backlog

Priority

normal

Type

task

Assigned

— db

Created by

wi-cli-venus

Created

2026-06-09T18:03:15.433Z

Updated

2026-06-09T18:03:15.433Z

Sub-items

Questions

Event log

• 2026-06-09T18:03:15.433Z · created · wi-cli-venus
• 2026-06-09T18:03:43.487Z · spec · wi-cli-venus
  Elazar (2026-06-09): 107 users w/ orphan auth (never logged in) — won't log in now. Soft-deactivate (flag, not hard delete; preserve for audit). db: confirm exact count + define 'orphan auth/never logged in' predicate before bulk deactivate, report scope to PM first. setArchiveContext on mutation (users is audited). Not urgent.
• 2026-06-09T18:12:29.921Z · note · wi-cli-venus
  db Phase-1 (2026-06-09): predicate auth.last_sign_in_at IS NULL AND deletedAt IS NULL AND surrogateOfUserId IS NULL → 113 users (not 107), 0 logins by auth+appEvents both. Roles: 98 alumno / 14 ayudante / 5 jtp / 2 adjunto / 1 titular. FORK: NOT junk — 98 have active studentAssignments, 18 have teacherComisionMemberships (imported+assigned, never onboarded). 0 practicas. No isActive column; mechanisms = auth.banned_until (login-block, no app rows, reversible) vs deletedAt (strips rosters/KPIs). Phase 2 HELD pending Elazar. PM rec: do NOT deletedAt assigned users — they're MARS-87 self-onboarding seed data; auth-ban at most. Ties to MARS-87.