MySQL Forums
Forum List  »  Newbie

Re: Track Data Changes
Posted by: Phillip Ward
Date: September 08, 2017 04:54AM

Quote

The requirement is to watch a database table in MySQL database for any data changes (CRUD operations) and report it

Question: Why?

If the idea is to "audit" legitimate changes made to sensitive data (who changed it and when and what did it look like before and after) then I'd suggest triggers that populate a separate "audit" table.

If the idea is to find someone who's doing something that they shouldn't be doing, then you've got a far bigger problem, namely that your permissions model has run away from you and you need to spend some time and effort locking things back down again properly

Regards, Phill W.

Options: ReplyQuote


Subject
Written By
Posted
September 08, 2017 01:16AM
September 08, 2017 01:59AM
Re: Track Data Changes
September 08, 2017 04:54AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.