Security & Mobility Now
Security is top-of-mind everywhere, especially right here where Juniper experts share their thoughts on the latest security breakthroughs and product advancements
KyleAdams

The Yahoo Breach: Not All SQL Injection Attacks Are Created Equal

by Juniper Employee ‎07-12-2012 01:40 PM - edited ‎07-12-2012 04:00 PM

Early this week, Yahoo joined the ranks of many other large organizations that were successfully and publically breached this summer.  The group claiming responsibility, known as ‘D33Ds Company, claims the breach was intended as a wakeup call to Yahoo’s security team and not as a malicious act.  The breach involved the extraction of sensitive information such as the usernames and passwords or nearly half a million users, as well as the full database architecture of the web application. D33Ds Company was able to steal the information by exploiting a SQL injection vulnerability in an undisclosed Yahoo! web application that some have speculated is related to the company’s VOIP phone service. 

 

To understand how to prevent becoming a victim of this type of attack, it’s important to how SQL Injection works and the different types of attacks. Most modern web applications such as the one breached by D33Ds Company involve two major components to operate. The first is the logic required to operate the application, the second is the database used to store persistent information like user credentials.  When a user submits data such as their username and password into a website, the logic portion of the application makes a request to the database to validate the credentials provided by the user (does the username exist, and is the password correct?).

 

A SQL injection attack is designed to exploit insufficient controls over the types of requests a user can submit, which allows an attacker to request information from the database that it isn’t intended to provide. For instance, asking the database if a user’s password starts with the letter ‘a’, if not, how about ‘b’ etc.  In the Yahoo example, attackers identified this type of vulnerability and leveraged it to extract every byte of information from the database. 

 

However, not all SQL Injection attacks are equal. Some can be more destructive than others. The specific flavor of SQL injection  used in the Yahoo attack, known as Union Based, is arguably the most destructive. This attack enables the attacker to extract extremely large chunks of data in a very short amount of time.  It’s the difference between requesting each password one at a time (normal SQL injection), letter by letter (Blind SQL injection) or requesting hundreds of passwords in one shot (Union Based).  Union Based attacks also make identifying the attack far more difficult because many preventative measures rely on the large volume of requests and time required to extract sensitive information as a way to identify and stop an attack in progress. Union attacks are very quick and require very few requests, making it more difficult to detect abnormal activity.

 

While SQL injection attacks are becoming fairly common, preventing them is not necessarily an easy endeavor.  The preferred method is for companies to perform extensive reviews of the code which interacts with the database.  These reviews help identify cases where an SQL injection attack may be successful, and once identified, the company can update the code to prevent an attack.  This is not always possible, as the code may have been written by developers from other companies, ex-employees, or the code may not be available for review or modification at all.  Aside from that, reviewing code is time consuming, requires skilled eyes, and is a point-in-time solution which must be repeated after every product update.  For these reasons, many companies simply can’t accommodate the level of review necessary to avoid a breach.  With that in mind, companies who are concerned about the possibility of a breach (which should be everyone!), must seek alternate solutions.

 

Mykonos Web Security for example, is a drop in minimal configuration solution that is designed to help address this problem.  When an attacker targets a website, there is an extensive amount of work that must be done before a breach can be successful.  This work involves probing and reverse engineering the web application and attempting to identify specific conditions the original developers had never anticipated.  This is the type of activity that Mykonos looks for and stops.  Once a malicious user is identified, they can be effectively stopped long before any valid exploits are discovered.  Other solutions are available, but primarily focus on detection and less on real-time prevention.  Web application firewalls for example, are effective at stopping known and automated SQL injection attacks, but are not difficult for skilled attackers, such as D33Ds Company, to bypass. You can see a demo of Mykonos here.

 

In addition to external protective measures like Mykonos, companies should also consider implementing tighter restrictions on their database, ensuring that users only have rights to access and manipulate data necessary to do their jobs.  Giving the web application full unrestricted access to all database data and features is a common mistake in many web applications, which dramatically compounds the damage caused by a successful SQL injection attack.  Companies should also consider other protections, such as encrypting sensitive information like passwords, or even storing that information in a secondary database with highly restrictive policies. 

 

From a consumer’s perspective, the Yahoo and other similar breaches could have significant security consequences and they should take action. For one, several people re-use the same password on multiple website, which allows people to compromise multiple accounts at once. As a best practice, people should use different passwords and change them regularly to avoid being a victim.

 

However, ultimately the responsibility to prevent these types of attacks rests squarely on companies that need to protect the information their customers trust with them.

 

Post a Comment
Be sure to enter a unique name. You can't reuse a name that's already in use.
Be sure to enter a unique email address. You can't reuse an email address that's already in use.
Type the characters you see in the picture above.Type the words you hear.
Labels
About the Author
  • Title: Senior Vice President and General Manager of the Branch Solutions Business Unit Area of Responsibility: Driving Juniper business including strategy, revenue/profitability, products and execution for this segment of SLT's overall portfolio, specifically comprehensive solutions for the small to medium size locations of large, distributed enterprises. Alex joined Juniper in February 2008 after more than five years at Extreme Networks, where he served as Chief Operating Officer from mid 2002 through 2006, and the last year as VP and GM of Extreme's high-end switching business and core engineering operations. During his tenure at Extreme Alex led programs which established essential product lifecycle and quality systems, completely refreshed the product portfolio, significantly improved product and service quality and margins, and streamlined the supply chain. Prior to Extreme Alex served as Chief Operating Officer for LCG Wireless (acquired by ADC Telecommunications), SVP Business Operations for ReplayTV, and earlier spent eight years in various executive roles with Octel Communications (acquired by Lucent Technologies) as CIO, SVP Business Operations, and SVP and GM of Enterprise Messaging. Alex holds a bachelors and masters degree in electrical engineering from Washington University in St. Louis.
  • I am a geek who loves knowing how everything works. I spent 13+ years as a software engineer and then transitioned to technical marketing. Not only do I need to know the geeky bits, but now I get to know about the business side - the MBA comes in handy. I enjoy sharing Juniper's message with customers and educating folks about our great solutions. When I'm not busy working I enjoy spending time with my wife and two kids. We all enjoy being outdoors. Huge soccer fan. Crazy Chicago Bears fan!
  • I manage the SRX3K and 1K line of security service gateways. I have spent a decade working with networking devices and in the process have obtained the JNCIE certification.
  • CIO @junipernetworks; enterprise technologist, husband, father to 2 Millennials, guitar player, vegetarian, space enthusiast; always up for a coffee
  • Passionate about the Internet and the connectedness of all things. I came from a background in ISPs and telecoms networks. I pride myself in being able to design a service, not just a config, and planning for scalable operations. Monitoring and network management a speciality. In my spare time I'll probably be messing about with a map or GPS or looking for a country pub, often all at the same time.
  • In my role as a WW Technical Field Strategist, I am part of a small team working to help reduce the friction associated with the technical side of doing business with Juniper.
  • Bill is the Director of Federal Strategic Initiatives at Juniper Networks. In this role, Bill focuses on several areas unique to the needs of Federal Government customers, including product certifications, IPv6, and security. Bill came to Juniper Networks in January 2008 after more than 20 years in the IT community working with commercial enterprise customers, service providers, and the US Federal Government. Bill started his career as an engineering officer in the US Air Force after graduating with a Bachelor of Aerospace Engineering from the Georgia Institute of Technology. Bill has an MBA from the Wharton School at the University of Pennsylvania.
  • Brad Minnis, CPP is the Senior Director of Corporate Environmental, Health, Safety & Security for Juniper Networks, Inc. based in Sunnyvale, CA, where he is responsible for strategic design, implementation and management of the company’s security, safety, environment, crisis management and business continuity functions. He also leads the company’s efforts in corporate citizenship and sustainability, and manages the Corporation’s government-related security programs. Mr. Minnis has over 30 years experience in the Silicon Valley and has managed EHSS operations for a number of high tech companies, including Juniper Networks, 3Com Corporation, and National Semiconductor Corporation. Mr. Minnis’ specialties include security management, supply chain and product integrity, anti-counterfeit, occupational health and safety and crisis management. In his role as Cyber Incident Response Team Leader for Juniper, Mr. Minnis has managed numerous high impact cyber-related incidents and cross-functional responses. Mr. Minnis served for ten years in the United States Navy and has served in leadership positions the International Security Management Association (ISMA) and ASIS International, serving as Chairman of the San Francisco Chapter in 2003. He has also co-written several publications on software integrity assurance and supply chain security with organizations such as SAFECode. Mr. Minnis is certified as a Protection Professional by the Professional Certification Board of ASIS International and attended the University of Connecticut, where he received two certificates in Environmental, Health and Safety
  • I'm a Security Product Line Engineer and Security Researcher at Juniper Networks working with the High End (Data Center) SRX and ScreenOS platforms, along with the IDP Standalone appliances. Prior to joining Juniper Networks, I was a senior consultant with a network security consulting firm, working extensively with Juniper products, including design, implementation, managed services, and support. I'm a co-author of Junos Security, Configuring NetScreen/SSG Firewalls, and Configuring Juniper SSL VPN's. I have a deep interest in network security, especially around Malware and IPS, and DDoS.
  • Security strategist, architect, evangelist/prophet, former-CISO, brick layer, priest and short order cook…product manager, product marketeer, CTO, advisor, board member and SQUIRREL! My life? It’s like Blade Runner meets Beautiful Mind w/some Patrick Swayze Roadhouse violence mixed in
  • Darrell Hyde began his career in the managed hosting industry in 1997, joining HOSTING's management team in 2003. During his tenure Darrell has led HOSTING'S Network Operations and Network Engineering teams and has played a lead role in the organization's technical direction. As Vice President of Architecture, Darrell is tasked with leading service design for HOSTING's product portfolio and overseeing the organization's technology strategy. In his spare time, Darrell lives in Philadelphia with his wife and 2 cats and really hopes Chip Kelly can restore the Eagles to glory.
  • Deena Thomchick has spent over 20 years in technology with most of it focused on networking and security. She’s currently responsible for product marketing for Juniper Network’s next generation firewalls and security gateway products where she spends her time learning how organizations use firewalls to protect themselves. Her security focus prior to Juniper Networks includes seven years with Symantec and VeriSign working on anti-virus and SSL technologies respectively.
  • Erin O’Malley is a senior marketing manager for global branding at Juniper Networks. Her team's goal is to amplify the company's brand promise: "Your ideas. Connected." A promise that speaks to the importance of innovation and sharing of personal insights. Previously at Juniper, Erin managed social media for Juniper's security business unit and was a product marketing manager for the company's virtualization and cloud security solutions. She has also worked on the customer marketing team at VMware and as a marketing writer at various companies, including WSGR, Business Objects, and the TDA Group. Erin holds a B.A. in French from Penn State University and an M.A. in French from Middlebury College.
  • François Prowse is a Senior Systems Engineer for Juniper Networks, based in Brisbane Australia. Francois joined Juniper in 2006 as part of the New Zealand SE team, subsequently relocating to Australia. Prior to Juniper, Francois worked for four years at Alcatel in both operational and architectural roles, being jointly responsible for the construction of New Zealands' largest MPLS core network. Prior to Alcatel, Francois worked at UUnet, focusing on core network expansion in Europe. In all previous roles JUNOS has been the driving factor behind day to day operations, providing him with over 8 years of operational experience. Francois is a Juniper Networks Certified Internet Expert (JNCIE #144) which he obtained prior to joining Juniper Networks.
  • As a Strategy & Planning Architect at Juniper Networks, my main interest and focus is mobile space security. It is through that interest that I am participating in 3GPP standards. My background is quite versatile, ranging from field Systems Engineer, to Education Services and Customer Services Engineer, to Product Line Engineer. Many moons ago, I attained both CCIE and JNCIE. I advocate change and enjoy challenges. I have a PhD degree in Organization & Management, specializing in IT. My Master's degree is in Computer Science from the University of Toronto.
  • ISP Network Engineer currently enjoying the security side of the Juniper product range. Busy studying for the JNCIP-SP and ENT. Outside of work I enjoy the great outdoors: Mountaineering, Bouldering, Rock or Ice climbing, Tramping (hiking to non-Kiwis) and Snowboarding. I'm also a member of the Alpine Cliff Rescue Team in Christchurch, assisting is vertical rescues or those requiring specialist access or extraction techniques, crevasse rescue etc.
  • Greg Sidebottom is a Senior Engineering Manager in the Identity and Policy Management business unit at Juniper Networks. Greg has spent the last decade plus conceptualizing, architecting, designing, and leading the implementation of Juniper's SDX and SRC families of policy based service management applications. Previous to this, Greg held positions in the software and networking industries at Siemens, Cognos, Nortel, GTE labs subsidiary MPR Teltech, and the Alberta Research Council. Greg is an author of eight invention disclosures resulting in two patents issued and three pending. Greg holds a B.Sc. in Computer Science for the University of Calgary and an M.Sc. and Ph.D. in Computing Science from Simon Fraser University.
  • IT Professional, Space nut, News junky, Interested in the world, based in the SF Bay area
  • Jim Kelly, Senior Product Line Manager – CTP Products Juniper Networks. Jim Kelly is the senior product line manager for the CTP products where he is responsible for the CTP product direction, marketing and circuit emulation applications within Juniper Networks. Mr. Kelly has more than 28 years of experience in the networking industry in technical roles, sales, marketing, and product management positions. He started his career in the United States Air Force. He has worked for Wang, Digital Telecom Systems, American Airlines, Network Equipment Technologies, Carrier Access, and Nortel Networks. He started Juniper Networks federal DoD sales in July 2000 and joined Juniper Networks again in October 2005 through the acquisition of Acorn Packet Solutions where he was the director of sales and marketing.
  • John is a highly experienced IT professional with over 25 years in the Industry. He is the UKI security lead for Juniper Networks and previous to this has held various sales and sales management positions with Mimecast, Proofpoint, Cisco, EMC and PCS. He started his career with Siemens and Sun Microsystems as a Systems Engineer/UNIX trainer.
  • Kevin manages Juniper's Counter Security portfolio, delivering innovative solutions to better address the advanced threats targeting organizations today. Counter Security builds on Juniper's network security capabilities, focusing on providing protection for Web applications with technologies like Intrusion Deception and application DDoS protection; as well as identifying and mitigating internal Advanced Persistent Threats attempting to exfiltrate data. Security Intelligence—applying big data analytics techniques to identify the sources of threats, and propagating the information to enforcement points in real-time—spans the Counter Security portfolio. Prior to Juniper, Kevin managed the Content Security portfolio at Cisco, including IronPort Email and Web Security, and ScanSafe Cloud Web Security. Before joining IronPort and Cisco, he ran product management and marketing for Infotone Communications, an integration appliance start-up and managed a seed-stage technology investment fund. Kennedy started his career at Intel, where his responsibilities spanned from microprocessor design to marketing to sales to venture investment. Kennedy has a BSE Computer Engineering from the University of Michigan.
  • Kyle Adams is one of the lead developers for the Mykonos Web Security solution acquired by juniper networks in early 2012. With over 10 years of experience in web security and application development, Kyle helps identify and implement innovative security techniques to help combat the ever increasing wave of cyber-attacks. He studied at the Rochester Institute of Technology and holds a BS in Computer Science and a minor in Criminal Justice.
  • I'm a Network Security Engineer working with Vodafone in their Cloud and Hosting Services team based in Leeds, UK. My role is to implement, test and deliver secure cloud based solutions to external customers.
  • 20 years technology experience in sales, product management and marketing. 15 in security. Living the good guys versus bad guys fight every day.
  • Michel Tepper is a Juniper consultant and instructor working for Westcon Security in the Netherlands. He started working in ICT in 1987. Michel is also is a Juniper Ambassador. Currently he holds three Junos Professional certifications and a number of specialist and associate certifications on non-Junos tracks. Michel is an active member of J-Net and juniperforum.com, where he uses the nickname screenie referring to the ScreenOS with which he started his Juniper Journey.
  • 30 Years in Book Publishing, 20 years in Technical Book Publishing, including Apple Developer Press, Adobe Press, Nokia Developer Books, Palm Books, and since 2001, almost 10 years as consulting editor/editor in chief for Juniper Networks Book. Joined the company and started the Day One book line and in 2011, the new This Week book line.
  • I work at Poplar Systems - Juniper Authorized Education Partner, Russia. We teach official Juniper classes on Juniper routing, switching and security products since 2006. In 2012 and 2013 we received Gold Awards as a Juniper education partner of the year in EMEA region. Poplar employees are Juniper fans who are exclusively devoted to providing as-high-as-possible quality Juniper education. One aspect of this is the fact that currently all our instructors are at least 2xJNCIE certified.
  • Rajoo Nagar is a senior manager in product marketing at Juniper Networks. She is responsible for product marketing for Juniper's security solutions. Rajoo is a published author, her book “Telecom Service Rollouts” was published by McGraw Hill Professional.
  • Sr. director for security portfolio marketing @ Juniper. I've been in IT management and security for many moons, focused on product marketing and communications. Fascinated with internet culture and evolution, watching how it moves the markets and opens our minds.
  • Rob Cameron is the Director of Product Line Engineering for Juniper Networks' data center firewall product line. Rob and his team currently support the largest designs and architectures for the SRX Series data center product lines. In his six years at Juniper he has supported major accounts in the Midwest region of the US, worked on data center strategy, and supported the SRX Series data center firewall product line since launch. Prior to his work at Juniper, he worked at several consulting organizations focusing on network security and high-availability architectures. Rob has five published books on using security technology. This includes his recently released "Junos Security" book from O'Reilly media.
  • I'm a Product Line Manager in the Security Business Unit working on all things intrusion prevention-related. I've been in the security field since 1994 working on diverse projects such as developing HP's public-key infrastructure (PKI), building the first protocol anomaly-based IDS at Recourse Technologies (acquired by Symantec), integrating vulnerability management and IDS at VM vendor nCircle and managing IPS products at Cisco and Juniper.
  • Digital Marketing Manager at Juniper Networks APAC.
  • Jonathan Looney is a Senior Staff Courseware Developer at Juniper Networks. Before joining Juniper, he performed network engineering for a large enterprise, a regional ISP, and an application service provider (ASP). The holder of several industry certifications, he enjoys the freedom his job at Juniper gives him to both continually learn and also to share his knowledge with others through a wide range of media.
  • Scott is the Director of Product Marketing for Mobile Security at Juniper Networks. In his 20+ years in high tech, Scott has worked on Mobile and Endpoint Security, Network Security, IPS, Managed Services, Network Infrastructure, Co-location, Microprocessor Architecture, Unix Servers and Network Adapters. He has held leadership roles at Check Point, McAfee, Symantec, Exodus Communications, Cable & Wireless, Savvis, and HP.
  • Networking & Security nerd (geek overall), Hockey fanatic, and Junos junkie! Born and raised in Grand Rapids, MI, with a few years of my life out in MN. Been in the IT field since I got out of High School. I've used Juniper products since around 2007, and really enjoy working with them. I currently work for a large retailer based in MI, with a footprint all across the Midwest.
  • Seema is a Sr. Product Marketing Manager of Security products. With over 10 years of experience in the network security field, she has been focused on sales enablement, product marketing and competitive intelligence at Check Point Software, Imperva, Webroot Software and Juniper Networks. Seema holds a B.S. in Computer Engineering from San Jose State University, California. Outside work, she loves to keep up with tech news, travel with family, listen to East Indian music (Bollywood, classical, and hip hop, depending on the mood) and attend concerts.
  • Sherry Ryan is IT Vice President and CISO of Juniper Networks. Previously, Sherry held similar positions at Blue Shield of California, Hewlett-Packard, Safeway and Levi Strauss where she established and led their information security programs. Sherry holds the Certified Information Security Manager (CISM) certification from ISACA and the Certified Information Systems Security Professional (CISSP) certification from ISC2. She is a member of the High Tech Crime Investigation Association (HTCIA) and the Information Systems Security Association (ISSA). Sherry has a bachelor's degree in Business Administration from the University of Redlands, and earned her MBA from the College of Notre Dame.
  • Timothy LeMaster is Director of Systems Engineering at Juniper Networks, where he is responsible for driving product development efforts to meet the demands of U.S. federal customers and for overseeing the activities of Juniper’s federal business unit systems engineers. A government IT industry veteran, Tim leverages his more than 15 years of experience in telecommunications and networking for the benefit of Juniper’s federal customers. Prior to Juniper, Tim spearheaded the development of applications aiding the government in the management of a very large SONET/IP network for IT solutions provider Veridian. Tim has also held several positions in the government, ranging from network operations and network modeling to engineering. Tim is a former U.S. Air Force officer.
About Security & Mobility Now

Discussing a wide range of topics impacting enterprises and
data center security.

Subscribe RSS Icon

Our Bloggers

Kyle Adams
Senior Software Engineer

Profile | Subscribe

Ritesh Agrawal
Director
Software Engineering

Profile | Subscribe

Erin K. Banks
Senior Technical Marketing Manager

Profile | Subscribe

Ajay Bharadwaj
Product Manager

Profile | Subscribe

Michael Callahan
Vice President
Product Marketing

Profile | Subscribe

Scott Emo
Director
Product Marketing

Profile | Subscribe

Mora Gozani
Senior Manager
Product Marketing

Profile | Subscribe

Ashur Kanoon
Sr. Manager
Technical Marketing

Profile | Subscribe

Seema Kathuria
Manager
Product Marketing

Profile | Subscribe

Kevin Kennedy
Senior Director
Product Management

Profile | Subscribe

Dave Killion
Software Engineer

Profile | Subscribe

Rebecca Lawson
Senior Director
Product Marketing

Profile | Subscribe

Rajoo Nagar
Senior Manager
Product Marketing

Profile | Subscribe

Erin O'Malley
Manager
Product Marketing

Profile | Subscribe

Galina Pildush
Strategy & Planning
Architect

Profile | Subscribe

Edward Roberts
Director
Product Marketing

Profile | Subscribe

Bill Shelton
Director Field Sales

Profile | Subscribe

Ashutosh Thakur
Product Line Manager

Profile | Subscribe

Troy Vennon
Software Engineer

Profile | Subscribe

Brad Woodberg
Product Manager

Profile | Subscribe

Copyright© 1999-2013 Juniper Networks, Inc. All rights reserved.