Discussion Locked

Database related Security Risks - Who has responsibility?

0 helpful
13 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Scenario:

I work for a company that purchased a bespoke web based database application a couple years ago. We hold highly sensitive personalised information, so security is important.

The company that created the system for us is a bit of a joke. But as it was all done before I came along, nothing i can do about it. (we are in the process of looking for someone else to do a rewrite and support the dang thing)

Anywho's, poking about this morning..(not my job to do so, but occasionally do so for the entertainment value...) and look-see what I found in the Web.config file (inetpub/wwwroot/appfolder):

Keep in mind, I have replaced the values with asteriks, in the file, they are there in plain view.

Now..if something would have happened in the previous 2 years and someone was going down for it..who has responsibility??

Is it our fault for not having web dev's to look after this, or is it their fault for developing it like this in the first place??

Just curious...
Now as I'm the one who found it, i get the pleasure of asking them to get their heads out of their @sses and explain why this is there as well as ask (nicely) that it be changed immediatly.

13 replies

by shellbot

i actually laughed when i saw it..

in fact i'm still laughing, reason being is that it normally takes them 3-5 days to respond to one of my emails...i got a response in less than 7 minutes when i sent them an email asking for an explanation.
No answers yet, but they are "looking into it".

:)

by tony hopkinson

running around gibbering 'Not me guv' and fighting over the IIS admin manual to place down the back of their own trousers.
:p

by shellbot

i think you missed the point..
we've paid these guys X amount of money and they leave our massive security risk like that open?

I know it can be encrypted....the point is..they didn't. And the email they got from me told them that it a rather b1tchy way.

Its a political thing..I'm the DBA..I'm not authorised to make modifications to the web application. So I don't. I just poke around and point out the horrendous errors in the stupid thing :)

by drurys

It seems to me that, in Ireland (and your profile indicates that your location is Dublin, IE), the data holder would be responsible under the Data Protection Act for keeping such data secure. In other words, your company has a legal obligation for data security.
If you get software developed by a 'Mickey Mouse' company, then you have to expect to get 'Mickey Mouse' software. I suggest that your company should have tested the software sufficiently to ensure that the data would be secure.
So, within the company you might blame the person who awarded the work to 'Mickey Mouse' or the person who signed off on the final product and implemented this less than satisfactory system.

by shellbot

Thanks Drury! I needed that :) Its friday after all.

"Tested"??? The thing was live for 3 months before they hired me to do support/dba work for it.
"Signed off"??? No one ever actually signed contracts. I found a draft SLA kicking about that was never signed either.

I'm the only person in the place who knows anything about this type of stuff..i have nightmares..i shudder at the thought of what is going to crash next and how long will it take to be fixed..and when thats fixed..what will they have broken in the process
:)

i'm always looking for a new job, but thing is..its not a bad place to work..so i reckon as long as i keep my head on me and just document document document..I'll be grand for a while yet :)

by jon

Dear Shellbot

I think you should take dryrys response very seriously. Your action could be to inform your management about the problem in a language understandable to them.

In that way you should expect the management to find the necessary resources to rectify the problem. If the management does not do that, then at least you can sleep at night assured that you made an attempt to solve the problem.

Save your mail to the management in case the authorities starts asking questions.

by drurys

You said yourself that your company holds "highly sensitive personalised information, so security is important". It doesn't sound like the latter statement is true, judging by your most recent post.
So, maybe it's your own company that is the 'Mickey Mouse' organisation!
My advice? Whatever you do, document it. If you care about the company's attitude to security, tell them - then leave.

by dr_zinj

You found the mistake, you get to recommend the corrective action.
If you're not the person in charge of IS (and I assume as a position of DBA that you are not), then it's up to your boss to find and implement the fix. However, finding and successfully implementing a security fix of this nature could be a jumping point for you in this company, so make the most of it.

by shellbot

Unfortuneatly they don't really understand, so I don't get a lot of brownie points.

I've pointed it out to the company we use for our application..they are "looking into the reason of why its like that"

We have no one in charge of IS. We've 2 networks guys who keep the email and networks up and running.

I'm it..and no matter how many times i save thier proverbial @rses, they don't really appreciate the mechanics of it. Its not thier fault, IT is not thier game and i understand that..
just frustrating to deal with thats all :)

by shellbot

I do take it serisouly..hence why I almost had a brain hemmorage when I saw the config file.

I've informed management, in a way they can understand it (not so easy to do all the time) and they are happy that I ask the development company that created the app to change it. So I've done so..

its just a cronic problem that gets to me sometimes, hence my flippancy..inherited a poor system, trying to keep it going with rubber bands and paperclips..management who can hardly use Outlook, never mind understand access issues bewteen web servers and databse servers..

*sigh*..all in a days work :)

by shellbot

I document everything. I have every email from the past 2 years..saved my butt more than once I'll say.

I totally agree re: Mickey Mouse..
we not really a mickey mouse company, but the attitude towards IT definatly is..
they want IT, but are unwilling to "invest" in IT..

I'm still waiting for either a helper OR a manager ..that was promised to me over a year ago. As the work keep piling up and up I smile and think..when I leave..they are so FUBAR'd.
Not that I'm all that great..but I'm the only one with any system knowledge..no other staff..no one to transfer information to..I'm only hanging onto the job because its a decent place to work for the money I'm getting paid..

Its just after a couple years of trying to save the world..you just say eff it and do your own thing..

This discussion is closed to new replies.