Board risk

When the auditor asks who changed that record

· Adrian Sullivan

Your systems can tell you what a number is right now. They very often cannot tell you who made it that number, or when, or what it was before. The current value is recorded. The history of how it got there is not. For most organisations that feels like a detail, until the day it is the only thing anyone wants to know.

A system that records the answer but not who put it there is a system that cannot be defended the day someone asks.

Picture the question arriving from outside. A regulator, an investigator, a customer’s lawyer, asks a plain one. Who altered this record, and on what date. In a defensible organisation that is a five-minute lookup. In a surprising number of organisations the honest answer is that nobody can say. The change happened. The trail did not. So the answer becomes a shrug, written on letterhead, to a person who does not accept shrugs.

Would it trouble you to learn that a figure in your financials, or a status on a customer file, could have been changed by anyone with access and left no record of who or when? Most boards assume that capability exists because the system looks expensive and modern. The application shows a tidy screen. Underneath, on the data that actually matters, change tracking is frequently switched off, or was never switched on, because it costs a little performance and nobody asked for it.

Here is the part that turns a technical setting into a board matter. An accountability gap is invisible while everything is calm. It only becomes real at the worst possible moment, during a dispute, an investigation, a fraud you are trying to prove or disprove. At that moment the absence of a trail does not read as a harmless omission. It reads as a failure of control, and the burden of explaining it lands on the people in the room, not on the database.

What would it take, today, for your team to prove that a specific record was changed by a specific person on a specific date over the last twelve months. Ask that question and watch the answer. If it comes back as confident and quick, good. If it comes back as we would have to look into that, you have found a disaster that has not happened yet, sitting quietly, waiting for the one question that makes it real.

You do not have to take this on faith from your own staff, and you do not have to start a project to find out. We run a free, read-only health check on your SQL Server. Fifteen minutes, no changes to anything, no sales follow-up you did not ask for. You get a graded report in plain English that says, among other things, whether the data that matters can answer the question who changed it, before someone outside makes you answer it for them.

Free health check

Want to know if this is sitting in your estate? We run a read-only check and hand you a graded report in plain English.

Get your free health check

← All posts