Comment On That's One Way to Secure It

Most of the WTFs we get are like light snacks. Some programmer didn't know better, screwed something up, we laugh at it, and hopefully everyone learns something. Other times WTFs are Homerian epics. Today's story is one of those. [expand full text]
« PrevPage 1 | Page 2Next »

Re: That's One Way to Secure It

2007-11-01 15:09 • by khedron (unregistered)
This is why I'm self-employed. No ridiculous cow orkers!

captcha: tesla (ouch!)

Re: That's One Way to Secure It

2007-11-01 15:11 • by Rex (unregistered)
That story was really funny around the lottery ticket thing, but by the end my heart just hurt.

Re: That's One Way to Secure It

2007-11-01 15:14 • by vt_mruhlin
So the intern waited 2 years to come back and get his stuff? Must have been important.

Re: That's One Way to Secure It

2007-11-01 15:21 • by FireJayPa (unregistered)
Wow that poor guy, my heart aches for him.

Having to deal with all of that nonsense; and I'm sure the intern came back for some EverQuest Screenshots that were on his machine

Re: That's One Way to Secure It

2007-11-01 15:23 • by Shannon (unregistered)
159645 in reply to 159642
Even worse, the intern still had security to access ANYTHING on the system after longer than a couple of hours of leaving, much less two years?

Re: That's One Way to Secure It

2007-11-01 15:25 • by James Schend (unregistered)
If the code was as bad as it sounds, and the intern as bad as he sounds, it's more likely he put in some kind of backdoor to either let him run ad-hoc queries on the data, or a pre-programmed sabotage query. That's what I'd guess... he might not even have done it from the office.

Re: That's One Way to Secure It

2007-11-01 15:32 • by Anonymous Coward (unregistered)
The steps the company took in the later part of the story reminds of a quote that scott hanselmann listed on his blog

"Customer walks in with a cell phone and says 'this thing needs a bigger antenna.' We have to ask ourselves does he want a bigger antenna or better cell phone reception" - Mark Klein

http://www.hanselman.com/blog/ReleaseISNOTDebug64bitOptimizationsAndCMethodInliningInReleaseBuildCallStacks.aspx

Re: That's One Way to Secure It

2007-11-01 15:37 • by Cope with IT (unregistered)
"Jared L. is our Odysseus in this story. As a fresh college graduate, he landed ..."

Odysseus went to college?!? ;-)

Re: That's One Way to Secure It

2007-11-01 15:40 • by FireJayPa (unregistered)
159650 in reply to 159649
Yes,

He went to College in that gap that isn't accounted for after the Illiad ...

Re: That's One Way to Secure It

2007-11-01 15:45 • by snoofle
159652 in reply to 159650
So Jared put up with that mess for two years? Sounds like he needs to learn when to stop beating his head against a wall... Sometimes it's best to walk away.

Re: That's One Way to Secure It

2007-11-01 15:54 • by pico suave (unregistered)
Well, it's nice to know that I'm not the only one at a company that received lottery tickets in lieu of a well-deserved bonus.

I was working as a tech support rep (doing a good deal of application programming in addition to taking calls and finding workarounds for bugs) and working regular 10 hour days. Aside from the lottery-ticket bonus, I was also denied a promised raise for nearly 2 years.

Why do we let this kind of thing happen to ourselves?

Re: That's One Way to Secure It

2007-11-01 15:54 • by gabba
What happened with the consultant? That detail was not addressed in this otherwise spellbinding story.

Re: That's One Way to Secure It

2007-11-01 16:02 • by Neal (unregistered)
So now we know how Jared REALLY lost all that weight. Curse you Subway!!!!!!!!

Re: That's One Way to Secure It

2007-11-01 16:14 • by worsethatuseless
159658 in reply to 159655
The thing I don't get is why the user names thing was so big a deal. Have everyone e-mail you there username and run them through the same filter to get a backwards map and then run that on the table. About 10 lines of code to generate the map and not a lot more to run the database updates. What am I missing?

Re: That's One Way to Secure It

2007-11-01 16:20 • by jtl (unregistered)
159659 in reply to 159658
"Have everyone e-mail you there username"

So your solution is to spam everybody and make the company look incompetent?

Re: That's One Way to Secure It

2007-11-01 16:21 • by Joe (unregistered)
159660 in reply to 159655
Neal:
So now we know how Jared REALLY lost all that weight. Curse you Subway!!!!!!!!


It was actually Aids

http://en.wikipedia.org/wiki/Jared_Has_Aides

Re: That's One Way to Secure It

2007-11-01 16:33 • by Schnapple (unregistered)
159661 in reply to 159652
snoofle:
So Jared put up with that mess for two years? Sounds like he needs to learn when to stop beating his head against a wall... Sometimes it's best to walk away.


Well he was fresh out of college with no experience. I'm sure prospective employers would say "so you don't have any experience except for this one job you're trying to run away from..."

Re: That's One Way to Secure It

2007-11-01 16:38 • by ParkinT
Obviously, the barely-competent company had no backups of the database (to which they could revert to correct the "F" ing problem)

Is it a bit of Poetic Justice the way the Intern "F"-ed up the database?

Re: That's One Way to Secure It

2007-11-01 16:42 • by Veinor (unregistered)
159663 in reply to 159658
worsethatuseless:
The thing I don't get is why the user names thing was so big a deal. Have everyone e-mail you there username and run them through the same filter to get a backwards map and then run that on the table. About 10 lines of code to generate the map and not a lot more to run the database updates. What am I missing?


Erank, Erancis, Erancine, Steeanie, and Josee would like to have a word with you.

Re: That's One Way to Secure It

2007-11-01 16:53 • by akatherder
159664 in reply to 159663
Veinor:
worsethatuseless:
The thing I don't get is why the user names thing was so big a deal. Have everyone e-mail you there username and run them through the same filter to get a backwards map and then run that on the table. About 10 lines of code to generate the map and not a lot more to run the database updates. What am I missing?


Erank, Erancis, Erancine, Steeanie, and Josee would like to have a word with you.


Who is Josff? And who in the hell spells Stephanie with an 'f'?

Re: That's One Way to Secure It

2007-11-01 17:03 • by Thf bfst onf (unregistered)
159666 in reply to 159664
[quote user="akatherder"][quote user="Veinor"][quote user="worsethatuseless"]Erank, Erancis, Erancine, Steeanie, and Josee would like to have a word with you.[/quote]

Who is Josff?[/quote]
Josef?

Re: That's One Way to Secure It

2007-11-01 17:09 • by Digitalbath
159668 in reply to 159639
It hasn't happened to me yet, but I'm pretty sure if my company offered me a "raise" of lottery tickets or no raise at all in my yearly review, I would be immediately polishing up my resume and sending it out to all my head hunter buddies. I think company loyalty is major BS. I work for you, help you make more money, then you give me a raise...end of story.

Plus, if they can't afford to give raises, who knows how long they are even going to be in business or how long your position is going to be around. No sense in waiting around to see what happens, IMHO.

Re: That's One Way to Secure It

2007-11-01 17:10 • by my name is missing (unregistered)
So the solution to the companies issues was using a single password for everything and giving no one access to anything. Sounds like a government solution to me.

Re: That's One Way to Secure It

2007-11-01 17:33 • by Shinobu (unregistered)
159671 in reply to 159664
akatherder:
And who in the hell spells Stephanie with an 'f'?
I don't really know about hell, but here on earth it's quite common.

Re: That's One Way to Secure It

2007-11-01 18:26 • by Troy Mclure (unregistered)
159673 in reply to 159642
vt_mruhlin:
So the intern waited 2 years to come back and get his stuff? Must have been important.


I read the entire story and thats what bugged me the most. It was 2 years + 4 months. Who does that?

Re: That's One Way to Secure It

2007-11-01 18:34 • by punissuer
159674 in reply to 159663
Veinor:
worsethatuseless:
The thing I don't get is why the user names thing was so big a deal. Have everyone e-mail you there username and run them through the same filter to get a backwards map and then run that on the table. About 10 lines of code to generate the map and not a lot more to run the database updates. What am I missing?


Erank, Erancis, Erancine, Steeanie, and Josee would like to have a word with you.
I think what worsethatuseless means is that Stefanie emails you, you run her name through the "same filter" (tr/eE/fF/), and now you know that in the database, "Stffanif" means Stefanie. It sounds like a pretty slick plan, except for one thing--the users aren't a database you can query at your leisure. As a group, they won't answer your beck and call the way Oracle does (for instance), and they won't appreciate being treated that way.

Re: That's One Way to Secure It

2007-11-01 18:46 • by Lingerance
159675 in reply to 159674
punissuer:
Veinor:
worsethatuseless:
The thing I don't get is why the user names thing was so big a deal. Have everyone e-mail you there username and run them through the same filter to get a backwards map and then run that on the table. About 10 lines of code to generate the map and not a lot more to run the database updates. What am I missing?


Erank, Erancis, Erancine, Steeanie, and Josee would like to have a word with you.
I think what worsethatuseless means is that Stefanie emails you, you run her name through the "same filter" (tr/eE/fF/), and now you know that in the database, "Stffanif" means Stefanie. It sounds like a pretty slick plan, except for one thing--the users aren't a database you can query at your leisure. As a group, they won't answer your beck and call the way Oracle does (for instance), and they won't appreciate being treated that way.

The fact that they probably can't login to email you might also be quite prohibitive.

Josee is a name btw.

Re: That's One Way to Secure It

2007-11-01 19:06 • by A Gould (unregistered)
159677 in reply to 159653
pico suave:

Why do we let this kind of thing happen to ourselves?


Because we want to believe the company acts in our best interest. (Like in "the good old days").

It's pretty much the dirty secret of corporate HR - as much as they want "retention" and "rewarding excellence", they want it for the lowest possible cost.

I spent a year as management, and it was a real learning experience to see how employees are seen from the other side.

Re: That's One Way to Secure It

2007-11-01 20:08 • by Aidan (unregistered)
josee (n): one who is josed

Re: That's One Way to Secure It

2007-11-01 20:35 • by Perplexed (unregistered)
So let me get this straight - this guy is hired out of school as the Webmaster / Java developer for these sites and doesn't feel obligated, let alone entitled, to make sure the new site is being developed properly? The "he was the boss' neighbor's kid" excuse sounds a little thin to justify spending 4 months (months?!?) reading instead of jumping in and maybe identifying the issues earlier. If I were his manager I'd be upset that Jared hadn't taken more ownership early on, especially given that the other two developers were temporary.

Re: That's One Way to Secure It

2007-11-01 20:39 • by anon (unregistered)
159680 in reply to 159675
Or when the user logs in, tr/eE/fF/ on the username, look it up in the database, and update it with the correct spelling.

Re: That's One Way to Secure It

2007-11-01 20:51 • by Perplexed (unregistered)
And another thing- is the article really pushing the notion that Jared couldn't develop and test without directly accessing code and data in *production*? If development and test environments weren't available and accessible, there's no better time to force the issue. Worst case, just set up your own local database and webserver if you have to. This just reads like he was working the wrong way for a long time, someone blocked his ability to work the wrong way, and he quit, probably never having bothered to ask or understand what processes were in place.

Re: That's One Way to Secure It

2007-11-01 22:25 • by Arancaytar
Regarding the database fixing: At least with first names, it would have been easy to use a dictionary-based guessing system. Last names more tricky, but with a few rules about pronunciation most of those would have been taken care of too. It leaves perhaps a hundred edge cases.

The database was big enough to justify a heuristic approach - let alone that programming a computer to sort out those letters is far less traumatizing than doing it yourself.

Re: That's One Way to Secure It

2007-11-01 23:08 • by Dd (unregistered)
2 years? I went back to my ex-workplace to pickup some things after 6 months once and all that was left was a smoking crater.

Re: That's One Way to Secure It

2007-11-01 23:34 • by freakwent (unregistered)
159688 in reply to 159653
Because we haven't got a good union.

Just wait for a minute.

Just think.

What happens in a 2-week strike of all IT people?

A month, nationwide -- or worldwide! Port workers have done it....

Just how much is it worth to corporates to avoid that sort of thing?

There's your pay rise, right there. Organised labour.

Re: That's One Way to Secure It

2007-11-02 00:20 • by Nick (unregistered)
Later, everyone's passwords were changed to one password. One password common to everyone. Users weren't allowed to change their passwords, either. They also stripped Jared of his ability to work on any of the sites by revoking access to the servers, disabling all of the nightly batch jobs that he'd created, and deleting his user account from the production site. He wasn't even given read-only access to the code. And that's how Jared could no longer do his job.
How does this even happen? Didn't someone in IT say how stupid this was?

I contract for a government department managing their critical Oracle systems, as a government department we have audits every 6 months, part of the audit involves system security. One of the auditors recommendations was to disable the Oracle administrator account "because it was too powerful", they obviously didn't think about this for too long.

I told them it was the stupidest thing I have heard (not in those words of course), explained to them why, and refused.

Why don't IT departments actually stand up against management when they want something insane like this, ie. DO THEIR JOB.

Re: That's One Way to Secure It

2007-11-02 00:58 • by Lynx@Work (unregistered)
159692 in reply to 159691
Nick:
Why don't IT departments actually stand up against management when they want something insane like this, ie. DO THEIR JOB.

There's a number of reasons. One, in some places, it's cultural for people to just nod along with the management and then grouse in private. I can tell you guys it's extremely annoying to hear the grouses.

Two, in some places IT is viewed as a cost center, meaning it doesn't provide revenue and would need another department (commonly known as the User) to provide revenue. So in some cases, the decisions were forced upon the IT department by the Users and politically it was pretty suicidal to refuse.

But I do tend to agree that at least in my environment, IT management tends to be more "bend over" than "up yours". It's quite sad actually, considering how much implicit political power IT has nowadays.

As for the intern, it's a bit amusing in a dark way. For me, we are increasingly dependent on interns -- the line managers tend to see them as cheap resources, better than contract programmers. Yet that's probably the worst way to treat interns, and in the long run the absolute pits when it comes to relationships with tertiary insituitions.

Still, as evidence by this particular case, you really cannot expect interns to be as professional as, well, professionals are supposed to be. So we're caught in between wanting to give interns a more meaningful internship, and safeguarding the corporate's interests. It's really a no-win situation IMO.

Re: That's One Way to Secure It

2007-11-02 02:25 • by sirhegel
Been there, seen that... A couple of years ago in a company meeting I was voted to be the "most positive guy in the company". I was very surprised. As an award I was given a lottery ticket. Woo-hoo. Since that I have NOT been the most positive guy in the company.

Hey gimme a break, is there ANY sense in giving a lottery ticket as award in the first place? Most propably the ticket is less valuable than toilet paper - there's already something written on it so you cannot use it to write down notes, and it is not soft enough to be used as toilet paper. If - by coincidence - the awarded one happens to win couple of million bucks, he would most propably quit and stop wasting his/her valuable time for working.

Re: That's One Way to Secure It

2007-11-02 03:56 • by Make Lemonade (unregistered)
[quote]He wasn't even given read-only access to the code. And that's how Jared could no longer do his job.

Finally, Jared submitted his two weeks' notice and found another position.[quote]

See, now that's the wrong solution. What he should have done was to keep "working" there, and drawing the same paycheck, forever. Management clearly didn't pay any attention to anyone in his department unless something blew up, and even if it did he could point to his lack of access to get off the hook. He could then use his now-copious free time to do freelance contract work on his laptop -- a nice double-dip.

Re: That's One Way to Secure It

2007-11-02 04:13 • by blastard (unregistered)
159697 in reply to 159673
I once came back (to a place where I had been an intern) for a jacket after a year. It is gone again now.

Re: That's One Way to Secure It

2007-11-02 04:17 • by blastard (unregistered)
159698 in reply to 159693
sirhegel:
Been there, seen that... A couple of years ago in a company meeting I was voted to be the "most positive guy in the company". I was very surprised. As an award I was given a lottery ticket. Woo-hoo. Since that I have NOT been the most positive guy in the company.


HA HA HA HA HA HA HA HA HAHAHA!
HAHAHAHAAHAHAHAHAHAAAAAAHAHAHAHA!
Omg, that was so frakking funny!

Re: That's One Way to Secure It

2007-11-02 04:39 • by Me (unregistered)
159699 in reply to 159675
Lingerance:
punissuer:
Veinor:
worsethatuseless:
The thing I don't get is why the user names thing was so big a deal. Have everyone e-mail you there username and run them through the same filter to get a backwards map and then run that on the table. About 10 lines of code to generate the map and not a lot more to run the database updates. What am I missing?


Erank, Erancis, Erancine, Steeanie, and Josee would like to have a word with you.
I think what worsethatuseless means is that Stefanie emails you, you run her name through the "same filter" (tr/eE/fF/), and now you know that in the database, "Stffanif" means Stefanie. It sounds like a pretty slick plan, except for one thing--the users aren't a database you can query at your leisure. As a group, they won't answer your beck and call the way Oracle does (for instance), and they won't appreciate being treated that way.

The fact that they probably can't login to email you might also be quite prohibitive.

Josee is a name btw.

Thier email addresses will also have had the e-f translation, so that won't work too well. You will still need to phone people up, and of course everyone has had it drummed into them that they should not give out private details over the 'phone.

Re: That's One Way to Secure It

2007-11-02 05:14 • by sweavo (unregistered)
Graduates: If you secure an important key position of high responsibility fresh out of grad school, bear in mind you will be working for the sort of company that will give an important key position of high responsibility to someone fresh out of grad school.


Captcha: you spelled "tasty" wrong.

Re: That's One Way to Secure It

2007-11-02 06:42 • by Helix
TRWTF is that the article is 1192 words including the code segment, whereas Jake indicates that the article is 1349 words.

Re: That's One Way to Secure It

2007-11-02 07:31 • by Anonymous Coward (unregistered)
I once was rewarded a few months of overtime with an admittedly very fancy dinner. Although it didn't quite compensate for all the extra hours I put in, it was a nice token of appreciation. But I never worked overtime like that again.

If there is no room for a bonus, just say so. But being rewarded with 4 bucks for months of overtime? I'd consider that a downright insult. Worse than failure, indeed.

captcha: smile

Re: That's One Way to Secure It

2007-11-02 07:34 • by AnonAndOnAndOn (unregistered)
159706 in reply to 159703
Helix:
TRWTF is that the article is 1192 words including the code segment, whereas Jake indicates that the article is 1349 words.


Maybe some of it it hidden in comments.

Re: overtime

2007-11-02 09:03 • by Panencephalitis (unregistered)
Hahahah. Unpaid overtime. That's why I left IT for the field of medicine.

Wait -- What is that? 80-100 hour work weeks with no overtime???? CRRAAAAAAAAAAAAAAAPPPPPPPPPPPPPP!!!!!!!

*** Panencephalitis has left #med-school

captcha: bathe

Re: That's One Way to Secure It

2007-11-02 09:05 • by seamus (unregistered)
159712 in reply to 159692
Lynx@Work:
Two, in some places IT is viewed as a cost center, meaning it doesn't provide revenue and would need another department (commonly known as the User) to provide revenue. So in some cases, the decisions were forced upon the IT department by the Users and politically it was pretty suicidal to refuse.
Indeed. I think everyone's been on the receiving end of "Super high management person wants logically illogical change made to core function of critical application to satisfy his one-time and legally iffy request", but it's when all IT decisions are made based on what the balance sheet says, that the IT department becomes a truely horrible place to work.

Unfortunately, unless you work in a technology company you have to accept that CTO/CIO's boss will always overrule him if he has to. Just pray you get a CEO who likes technology.

Re: That's One Way to Secure It

2007-11-02 10:24 • by tsrtg (unregistered)
I would say that Jared was a clueless idiot who could not fix a simple corporate web site in 2 years. A web site that was created by somebody who was working 2 hours per day for a couple of months. Ha-ha.
And he could not even figure out how the intern changed the data? Provided that he had all the information and moreover the intern's system was replaced by his own by that time? A true professional!
(BTW I suspect the intern has nothing to do with that, and the decision to stop all Jared's batch jobs was correct)

Re: That's One Way to Secure It

2007-11-02 10:33 • by Foomcbar (unregistered)
159715 in reply to 159714
Apparently tsrtg has never had to deal with the mountains spaghetti code that someone like that intern can produce.

2 years is a long time, yes, but seriously bad code can be really really difficult to just "fix".

Stopping the batch jobs, that probably actually did important things...yeah, great decision </sarcasm>
« PrevPage 1 | Page 2Next »

Add Comment