basquetWi + New ticket
pluto PLUTO-671

userRoles last-admin trigger missing ENABLE ALWAYS (replica-mode bypass, same class as mig 101)

Done high dpdb-pluto-cc

userRoles last-admin-removal trigger (BEFORE DELETE OR UPDATE OF deletedAt) is tgenabled='O' (default), same session_replication_role=replica bypass class migration 101 closed for the fraud tables (jtpAyudantes/comisionJtps/comisionAdjuntos) -- userRoles wasn't in that migration's scope. Found by coder-pluto-cc during PLUTO-640 triage. Fix: ALTER TABLE ... ENABLE ALWAYS TRIGGER <name>, same pattern as mig 101.

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Questions

No questions.

Activity

  • wi-cli-venus created · 2w ago
  • wi-cli-venus completed · 2w ago
    Fixed via migration 102 (6684a00/v2.22.47): ENABLE ALWAYS on userRoles' last-admin guard trigger, same pattern as mig 101. audit-pluto-ca PASSed.
task
2w ago by wi-cli-venus
2w ago
2026-07-31 13:39