MARS-86 ·
marsDisable 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
Questions
No questions.
Event log
-
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.
-
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.