• Registered: 2020-02-20
  • Posts: 12

Topic: dear all I'm not a coding expert. I need an audit trail on my project

Dear all,

I'm not a coding expert but I need an audit trail on several tables on mySQL database project. this is to ensure that every USER that updates, deletes or adds a new record can be identified with DATE AND TIME OF CHANGES.

Thanks

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,674

Re: dear all I'm not a coding expert. I need an audit trail on my project

Hello Senioke,
Is it just details of the user, date of change, time of change and type of change (add, update, delete) that is made?
Or do you also need to know the specific fields that have been changed and, if so, do you then need to know the 'old' and 'new' values of those fields?
Derek.

  • Registered: 2014-06-25
  • Posts: 863

Re: dear all I'm not a coding expert. I need an audit trail on my project

I do this with triggers, it takes quite a bit of time depending on the level of information you need but well worth it! https://www.mysqltutorial.org/mysql-triggers.aspx