Description
Currently, deleting a user can leave orphaned UserSession records in the database. These resources are ephemeral and personal, so they should be cleaned up automatically to maintain database integrity.
A targeted "Automated Cascade Cleanup" for sessions. When a user is deleted, the system should automatically purge any associated UserSession records without requiring manual transfer or admin confirmation.
A full ownership management UI was considered but pivoted to this lean approach to focus specifically on the immediate data inconsistency issue.
Additional context
This Epic tracks both backend and frontend tasks:
- Backend: API enhancement to support
cascadeResourceDelete.
- Frontend: Integration in the User Manager deletion flow.
Description
Currently, deleting a user can leave orphaned
UserSessionrecords in the database. These resources are ephemeral and personal, so they should be cleaned up automatically to maintain database integrity.A targeted "Automated Cascade Cleanup" for sessions. When a user is deleted, the system should automatically purge any associated
UserSessionrecords without requiring manual transfer or admin confirmation.A full ownership management UI was considered but pivoted to this lean approach to focus specifically on the immediate data inconsistency issue.
Additional context
This Epic tracks both backend and frontend tasks:
cascadeResourceDelete.