Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Actions auditability #187

Open
3 tasks
jmaupetit opened this issue Oct 9, 2024 · 0 comments · May be fixed by #196
Open
3 tasks

Actions auditability #187

jmaupetit opened this issue Oct 9, 2024 · 0 comments · May be fixed by #196
Assignees
@jmaupetit
Labels
API Item related to the API service critical

Comments

@jmaupetit
Copy link
Member

Purpose

We need to ensure that actions triggered by the API is auditable: who did what and when. For now, we are only able to track objects creation and update date/time (the when). We at least need the who.

Proposal

  • add a created_by foreign key to the User table for every models
  • add a updated_by foreign key to the User table for every models
  • add schema and data migrations
@jmaupetit jmaupetit added critical API Item related to the API service labels Oct 9, 2024
@jmaupetit jmaupetit self-assigned this Oct 9, 2024
@jmaupetit jmaupetit linked a pull request Oct 15, 2024 that will close this issue
Add database auditability #196
Draft
4 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jmaupetit jmaupetit

Labels
API Item related to the API service critical
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Add database auditability MTES-MCT/qualicharge
1 participant
@jmaupetit