Pratum Blog

I presented a session at the Nebraska Cert Conference yesterday about working with IT auditors. It was quite funny to watch the facial expressions of people in the room as the session progressed. At the beginning I asked for a show of hands to see if any IT auditors where present. About half a dozen in the crowd of around 30 raised their hand.

The basic premise of my presentation was that IT management needs to be more involved in the IT audit process. As the session progressed I saw lots of smiles and head nods from the auditors. The rest of the group nodded their heads in agreement, but it wasn't the same. It almost looked like a football team that was defeated before they even hit the field. They knew they needed to play the game but had resigned themselves to the inevitable outcome before the first snap.

This tells me something about our current climate. As the frequency and depth of IT audits are increasing due to the ever changing regulatory environment, tensions are running a little high. IT groups know they are under the gun. With every new regulation comes more work and an eventual audit. This can be quite a pressure cooker to operate in on a daily basis.

I place responsibility squarely on IT management to change this culture. My company's name is Integrity. In essence it's about doing the right thing even when nobody's looking. IT managers need to change the culture in their organizations. Not that anyone is doing a bad job but sometimes we let things slide when nobody's looking over our shoulder. Log analysis or documentation get put aside when you've got network outages or development bugs to fix. Then when an audit is announced the tension runs high because everyone knows there are some things that were shelved and never picked back up.

IT management needs to do a better job of making sure their teams are provided ample opportunity to do the job correctly and completely. They should even go so far as to require it. Make it a part of performance reviews if needed. When management takes the details seriously, so will their teams.

My guess is that once we start to sweat the details in IT, audits won't be so stressful. And when audits are so stressful, we might actually begin to appreciate what they tell us about our organizations.

Here we go again. Another record setting case involving identity theft. Fox News is reporting that Albert Gonzalez is responsible for the theft of 130 million credit and debit card numbers. Funny thing is…Gonzalez is already due to stand trial later in 2009 AND 2010 for two other data thefts. Maybe you heard about one of them…TJ Maxx?

Obviously details are just emerging but some intel suggests the accused and his co-conspirators were able to breach the systems using SQL injection attacks. If that's the case I think the organizations that fell victim should be held liable for criminal negligence. Here's my argument for why.

SQL injection is the technique hackers use to insert SQL statements, queries and commands into web-based systems in order to view or extract data which normally wouldn't be visible to the end user. This stems from input which is not validated.

When you enter a term into a search field to find products by name for example, the application takes your input and creates a SQL query which it send to the database. In a normal query, your search term is passed to the database as just that, a search term. Malicious users however will put in valid SQL statements into those search boxes that are then passed to the database. It could be a command such as "Send back the table of credit card numbers". The database sees this as a valid command and sends back the full table of credit card numbers. If this input isn't checked by the application, the "search term" will be sent over to the database and it will be processed for what it is. A database execution statement, not a search term.

The sad part is that this type of malicious activity is completely avoidable. There are tools which will check each one of your input variable to ensure they cannot be manipulated in this fashion. Oh…and these tools are automated. Sure they cost money (some of them) but the risk to the confidentiality, integrity and availability of a database system open to public intrusion is just too great to ignore. This is why I say find those responsible and charge them with criminal negligence.

Now…before you go hog wild on me, I know there are some legal issues to work through here. My point is, until the system owners have some real skin in the game this will continue.

So…give me your thoughts on this. Should system owners (business owners) and administrators (IT departments) have some sort of criminal penalty applied when proper risk mitigation techniques are not followed?


Somewhere along the road of technology integration into our daily business process, the role of information owner and data custodian become confused. Data only has value when there is meaning wrapped around it. The combination of data and meaning creates information. A business unit, and therefore business unit leadership, is the rightful owner of almost all, if not all of the information a business generates. The data owner is the person or entity for which the data has value. They are the ones who can open a spreadsheet and make sense of the rows and columns of numerical data. It's informational to them.

In contrast, the data custodian can't make heads or tails of most of the data they are asked to maintain. A spreadsheet of last month's sales numbers isn't any more valuable than next month's customer newsletter. It's just data to them. They are charged with making sure the data is secured and available to the owner when needed.

In many organizations, information owners have abdicated their responsibilities to manage and protect their information investments. They rely on IT to determine backup schedules, off-site rotations, disaster recovery, retention schedules, access controls and other things which impact the confidentiality, integrity and availability (CIA) of their information. In many cases the business unit leadership is markedly absent from any discussions or decision points regarding information CIA. They simply want to pass this on to IT to worry about as a "technical" issue.

By default, most IT organizations accepted this responsibility as they knew at some point data would be compromised and the business unit would look to them to fix it. Unfortunately, instead of pushing the responsibility back to the business unit to get involved in the process, they simply shouldered the burden and did what they thought was best.

If you take in a stray puppy and care for it, you might become attached to that puppy over the years. When the rightful owner comes back to claim it later, there could be some tension in those discussions. The same thing is happing with regards to our business information. IT has been caring for and feeding our data for years while the business units have largely neglected their responsibilities as information owners. IT has been doing the best they could with limited resources and knowledge of the constraints on the information.

Now under the gun due to regulatory environments, data owners are finding themselves on the hook and under scrutiny in regards to information security and privacy. Business unit leadership is suddenly very interested in what's happening with their information. They want to know the who, what, when, where, why and how.

We in IT need to embrace this newfound interest. Don't look at it as challenging your authority over the information. You never had any authority. It was an illusion. Take a deep breath and exhale a sigh of relief. No longer do you have all the responsibility with none of the authority. You can now provide recommendations to the business on appropriate safeguards but ultimately will take direction from them in regards to protecting their data. This is going to feel weird at first. Really weird…almost wrong. But trust me, in the end everyone will be happier and things will run smoothly when information owners and data custodians understand and embrace their roles in collaboration with each other.

The information we track while users are on our websites helps us analyze site traffic, optimize site performance, improve our services, and identify new products and services of interest to our users. To learn more please see our Privacy Policy.