There are inactive users who remain in the database, and we are managing user authentications based on the lastLoggedIn timestamp. We aim to implement a database trigger to remove users from the database if their account creation date exceeds 90 days without any login activity.
Why does this work belong in this project?
This initiative aligns with our strategy of enforcing user restrictions based on login activity, as outlined in issue #2458.
Implementation Notes
Develop a database trigger that compares today's date against the user's creation date. If the duration since the creation date has exceeded 90 days without login activity, the user should be removed from the database.
Acceptance Criteria
How do we know when this work is done?
[ ] A user is automatically removed from the users table when the time since their account creation exceeds 90 days without any recorded login activity.
💡 Summary
What is the work, as a high-level summary?
There are inactive users who remain in the database, and we are managing user authentications based on the
lastLoggedIntimestamp. We aim to implement a database trigger to remove users from the database if their account creation date exceeds 90 days without any login activity.Why does this work belong in this project?
This initiative aligns with our strategy of enforcing user restrictions based on login activity, as outlined in issue #2458.
Implementation Notes
Develop a database trigger that compares today's date against the user's creation date. If the duration since the creation date has exceeded 90 days without login activity, the user should be removed from the database.
Acceptance Criteria
How do we know when this work is done?