A community of more than 1,600,000 database professionals and growing

I was browsing the Internet and stumbled on a small part of a larger story that struck me. Many of you may have heard of the story of Jamal Khashoggi, the journalist for the Washington Post that was killed. I hadn't spent much time reading about the story, and I don't really want to discuss that topic here. The politics of the situation are not relevent here.

There's a part of the NY Times background story that caught my eye when a quote was posted on Twitter. This is part of that quote: " The intelligence officials told the Twitter executives that Mr. Alzabarah had grown closer to Saudi intelligence operatives, who eventually persuaded him to peer into several user accounts". Essentially, an employee at Twitter was accused of accessing, and potentially disclosing, sensitive data about customers. This is what I want to discuss.

In my career, there are quite a few times that I've had to access data to solve some problem, debug an application, or produce a report. In many cases, I've had to maintain some confidentiality of the data, not even discussing specifics with other employees that were not supposed to view that information. To me, that's just part of being a professional. We handle all sorts of data, some of which we should never use outside of solving an issue or producing a report.

As I thought about what was alleged here, I wonder how many social media companies have controls or auditing to determine who has accessed information. Would they be able to actually produce a report that validates some assertion that data was, or was not, accessed. I doubt many companies have these kinds of controls. Unless some Excel file or other export was on a file share, would there be evidence?

Then I thought does anyone really do a good job of producing audit records for information access? I know some government and law enforcement systems do this (and some legal software), actually tying queries and results to some individual and even a piece of work. That's not the nature of information for most of us, though perhaps it ought to be.

Auditing data, especially for information access, could be a huge amount of data. Even keeping a record of all user access for a week in most SQL Server databases might be more data than many of us have in our database. I do think we ought to have the option, and I'd hope that we get more detailed, more capable, and more configurable methods of auditing SQL Server activity in the future (Hint, give us SQL Audit data in a csv).

Join the debate, and respond to today's editorial on the forums

In this case, the column does not create a deterministic value, so it cannot be indexed.

Ref: CREATE INDEX - click here

» Discuss this question and answer on the forums