CREATE A AUDIT LOG IN QUERY BY USER

IT WOULD BE HELPFUL TO GENERATE AN AUDIT LOG IN QUERY OF ALL THE CHANGES MADE TO THE RE/NXT DATABASE BY USER NAME. THIS WAY I CAN TRACK WHO IS ADDING & UPDATING RECORDS AND GIFTS IN THE RE/NXT DATABASE

  • Adrienne Smart
  • Aug 3 2022
  • Attach files
  • Devan Caton commented
    05 Sep 13:16

    YES. The fact that RE does not have any kind of audit log feature is mind-blowing and a tragedy. Our auditors regularly ask for that kind of info, and we have to just tell them there's no way to pull that from the system. Never mind the auditors... it would be helpful from a DBA and/or management perspective to be able to identify staff who need additional training, processes that need refinement, etc.