Dark Reading is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.


10:13 AM
Adrian Lane
Adrian Lane

Discovery And Your Database

Database discovery is the act of locating databases on a network. Years ago, this was simple because companies had only one or two databases. Now just about every application created relies on database services to provide data integrity and transactional consistency.

Database discovery is the act of locating databases on a network. Years ago, this was simple because companies had only one or two databases. Now just about every application created relies on database services to provide data integrity and transactional consistency.As is common with SQL Server, a single installation can support hundreds of database instances. With virtualization and mirroring in wide use for disaster recovery, these databases move and propagate automatically. Many desktop applications embed "lite" versions of enterprise databases, scattering databases across the endpoint. With companies having geographically disperse locations on networks further segmented by business function, finding and itemizing different databases is a complex task.

Each database in an organization poses a security risk. The risk is both in the data it houses and as a potential target for attackers. Forensic analysis of major data breaches has proved highly sensitive data has been stolen from unsecured test servers, and databases with poor security are leveraged to attack other database installations. Unless the database and data security settings have been adjusted from their default settings, they are not secure.

Discovery is not really a security operation per se, but finding databases is useful for a wide variety of security and operational tasks. The business motivation for database discovery is to itemize the databases in order to understand where these assets reside. Once discovered, this information is used to verify they conform to security policy through assessment. It is used by operations staff to check licensing and patch revision levels. It is used for data discovery tools to locate sensitive information. Databases communicate with other applications by setting themselves up to listen for communication requests at a specific location called a network "port." Most database discovery tools work by performing a scan of network ports on a server. As databases default (Oracle is port 1521, SQL Server is port 1433), automated network scanning tools will call these locations to see if there is a service listening. If so, it assumes a database is present. Most automated scanning tools accept a TCP-IP address range as well as port address ranges, and will look for specific database types. The scanner will attempt to communicate with the port and, depending on the response, can determine database type and possibly version.

If your company has only a handful of production databases, then database discovery is probably not appropriate for you. But if your firm has many applications and/or heterogeneous databases, then discovery tools are very helpful in managing database security. Both commercial and free tools are available, with variations on ease of use, speed of scan, and integration capabilities. Plan on running periodically to verify what you have, and locate new databases that have popped up.

Adrian Lane is an analyst/CTO with Securosis LLC, an independent security consulting practice. Special to Dark Reading. Adrian Lane is a Security Strategist and brings over 25 years of industry experience to the Securosis team, much of it at the executive level. Adrian specializes in database security, data security, and secure software development. With experience at Ingres, Oracle, and ... View Full Bio

Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
Manchester United Suffers Cyberattack
Dark Reading Staff 11/23/2020
As 'Anywhere Work' Evolves, Security Will Be Key Challenge
Robert Lemos, Contributing Writer,  11/23/2020
Cloud Security Startup Lightspin Emerges From Stealth
Kelly Sheridan, Staff Editor, Dark Reading,  11/24/2020
Register for Dark Reading Newsletters
White Papers
Cartoon Contest
Write a Caption, Win an Amazon Gift Card! Click Here
Latest Comment: This comment is waiting for review by our moderators.
Current Issue
2021 Top Enterprise IT Trends
We've identified the key trends that are poised to impact the IT landscape in 2021. Find out why they're important and how they will affect you today!
Flash Poll
Twitter Feed
Dark Reading - Bug Report
Bug Report
Enterprise Vulnerabilities
From DHS/US-CERT's National Vulnerability Database
PUBLISHED: 2020-11-30
SQL injection vulnerability in request.cgi in Synology SafeAccess before 1.2.3-0234 allows remote attackers to execute arbitrary SQL commands via the domain parameter.
PUBLISHED: 2020-11-30
Multiple cross-site scripting (XSS) vulnerabilities in Synology SafeAccess before 1.2.3-0234 allow remote attackers to inject arbitrary web script or HTML via the (1) domain or (2) profile parameter.
PUBLISHED: 2020-11-30
An issue was discovered on Fujitsu Eternus Storage DX200 S4 devices through 2020-11-25. After logging into the portal as a root user (using any web browser), the portal can be accessed with root privileges when the URI cgi-bin/csp?cspid=&csppage=cgi_PgOverview&csplang=en is visit...
PUBLISHED: 2020-11-30
hw/usb/hcd-ohci.c in QEMU 5.0.0 has a stack-based buffer over-read via values obtained from the host controller driver.
PUBLISHED: 2020-11-29
An issue was discovered on V-SOL V1600D V2.03.69 and V2.03.57, V1600D4L V1.01.49, V1600D-MINI V1.01.48, V1600G1 V2.0.7 and V1.9.7, and V1600G2 V1.1.4 OLT devices. It is possible to elevate the privilege of a CLI user (to full administrative access) by using the password [email protected]#y$z%x6x7q8c9z) for the e...