NEW: Microsoft Vulnerabilities Report 2022 - Read the Findings of Our Annual Report Read Now

  • Partners
  • Support
  • Careers
  • English
    • Deutsch
    • français
    • español
    • 한국어
    • português
BeyondTrust
  • Products

    Privileged Password Management

    Discover, manage, audit, and monitor privileged accounts and credentials.

    • Password Safe
    • DevOps Secrets Safe
    • Privileged Access Discovery Application

    Endpoint Privilege Management

    Enforce least privilege across Windows, Mac, Linux, and Unix endpoints.

    • Windows and Mac
    • Unix and Linux
    • Active Directory Bridge

    Secure Remote Access

    Centrally manage remote access for service desks, vendors, and operators.

    • Remote Support
    • Privileged Remote Access
    • Privileged Access Discovery Application

    Cloud Security Management

    Automate the management of identities and assets across your multicloud footprint.

    • Cloud Privilege Broker

    BeyondInsight

    Experience the industry’s most innovative, comprehensive platform for privileged access management.

  • Solutions

    Use Cases

    • Cloud Security
    • Compliance
    • Cyber Insurance
    • Digital Transformation
    • Endpoint Security
    • Operational Technology
    • Ransomware
    • Service Desk Efficiency
    • Zero Trust

    Industry Applications

    • Financial Services
    • Government Agencies
    • Healthcare
    • Law Enforcement
    • Manufacturing
    • Schools & Universities

    Solutions

    The BeyondTrust Privileged Access Management portfolio is an integrated solution that provides visibility and control over all privileged accounts and users.

  • Resources

    Learn

    • Blog
    • Customer Stories
    • Competitor Comparisons
    • Datasheets
    • Demos
    • Glossary
    • Podcast
    • Whitepapers

    Attend

    • Events
    • Go Beyond
    • Training
    • Webinars

    Support

    • Changelog
    • Professional Services
    • Technical Documentation

    Universal Privilege Management

    Our innovative Universal Privilege Management approach secures every user, asset, and session across your entire enterprise.

  • Company
    • About
    • Leadership
    • Core Values
    • Partners
    • Careers
  • Watch Demo
  • Contact Sales

Keeping Your Flat File Databases Secure

May 6, 2010

  • Blog
  • Archive

Just a few weeks ago Dark Reading featured an interesting article highlighting the risks and sensitivity of data in flat file database formats.

A lot of focus has been placed on database scanning, however users tend to ignore flat file databases used for applications and local data files that are produced as subsets. Very little information is present on best practices for securing flat file based databases and how to mitigate the risks of data contained within them.

It's a valid argument to suggest that database application servers are not as secure as flat files. To some this may seem reasonable, as standard database solutions may have more visibility as an attack vector. And if you consider that any file contained on a host could be sensitive with regards to the information contained within, flat file databases are more secure because of local permissions and the operating system itself.

However, flat files are only as secure as the permissions, operating system, and application services that protect the files. Unlike widely adopted RDBMS solutions which provide built-in auditing, event notification, encryption and granular access controls, applications that utilize flat files may rely on the application developer(s) to provide these services.

When deploying any new application or reviewing existing ones, I'd like to propose a process for investigating the data storage capabilities of the application. The Microsoft operating system does a good job keeping MS Office documents, and MS Access database files in the My Documents directory. This makes it easy to secure by user.

But what about applications that store flat file databases in nonstandard locations? What if the application uses nonstandard file extensions to mitigate the association of the files? What if your web application needs a flat file database? What if the application managing the data provides another layer of granular access control to the data?

As a part of the security model when reviewing a new or existing application, consider the following:

- How does the application store data? - What file format is the data stored in? - Can the file system be secured with permissions to isolate the files? - Does the local user need to be an administrator in order to access the files? - Can the files contain a different permission set then the user login? - Can you secure the services for the application with different permissions than the logged in user and the files? - Are temporary files created containing flat file data and are they purged when the application is complete? - Are the data files password-protected or encrypted? - What is the location of the files and can they be moved to a standard location for backup, deletion, and security? - Consider that even a text file and XML file can be considered flat file databases and are especially sensitive when used with web applications. - What auditing facilities are available to track access and changes to the file data?

In doing my research, I saw that very little information is available about securing flat file databases. There are only a few guidelines available, but nothing appears to be fully comprehensive to solve the problem especially for end user guidance.

If your organization stores critical data that may be a violation of regulatory compliance initiatives, be mindful. You will need to find this data and secure it just like any other secure process within your organization. Also consider, if these files are not secure what liability you may have if they are exposed. An HR spreadsheet can be considered a sensitive flat file database depending on the data it contains too.

Photograph of Morey J. Haber

Morey J. Haber, Chief Security Officer, BeyondTrust

Morey J. Haber is the Chief Security Officer at BeyondTrust. He has more than 25 years of IT industry experience and has authored three books: Privileged Attack Vectors, Asset Attack Vectors, and Identity Attack Vectors. He is a founding member of the industry group Transparency in Cyber, and in 2020 was elected to the Identity Defined Security Alliance (IDSA) Executive Advisory Board. Morey currently oversees BeyondTrust security and governance for corporate and cloud based solutions and regularly consults for global periodicals and media. He originally joined BeyondTrust in 2012 as a part of the eEye Digital Security acquisition where he served as a Product Owner and Solutions Engineer since 2004. Prior to eEye, he was Beta Development Manager for Computer Associates, Inc. He began his career as Reliability and Maintainability Engineer for a government contractor building flight and training simulators. He earned a Bachelor of Science degree in Electrical Engineering from the State University of New York at Stony Brook.

Stay Up To Date

Get the latest news, ideas, and tactics from BeyondTrust. You may unsubscribe at any time.

I agree to receive product related communications from BeyondTrust as detailed in the Privacy Policy, and I may manage my preferences or withdraw my consent at any time.

You May Also Be Interested In:

Whitepapers

Microsoft Vulnerabilities Report 2022

Whitepapers

Cybersecurity Insurance Checklist

Whitepapers

Privileged Access Management: PAM Checklist

Keep up with BeyondTrust

I agree to receive product related communications from BeyondTrust as detailed in the Privacy Policy, and I may manage my preferences or withdraw my consent at any time.

Customer Support
Contact Sales

Products

  • Endpoint Privilege Management
  • Password Management
  • Privileged Remote Access
  • DevOps Secrets Safe
  • Remote Support
  • Cloud Privilege Broker

Resources

  • Blog
  • Case Studies
  • Competitor Comparisons
  • Datasheets
  • Glossary
  • Podcast
  • Videos
  • Webcasts
  • Whitepapers

About

  • Company
  • Careers
  • Contact
  • Events
  • Leadership Team
  • Partner Program
  • Press
BeyondTrust Logo
  • Facebook
  • Twitter
  • LinkedIn
  • Privacy
  • Security
  • Manage Cookies
  • WEEE Compliance

Copyright © 1999 — 2022 BeyondTrust Corporation. All rights reserved. Other trademarks identified on this page are owned by their respective owners. BeyondTrust Corporation is not a chartered bank or trust company, or depository institution. It is not authorized to accept deposits or trust accounts and is not licensed or regulated by any state or federal banking authority.