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.

Perimeter

10/8/2009
10:10 AM
Adrian Lane
Adrian Lane
Commentary
50%
50%

Avoiding Database Audit Pitfalls

Many seasoned database administrators howl in protest at the mere suggestion of running native auditing functions due to the poor performance and log management headaches that often come with auditing.

Many seasoned database administrators howl in protest at the mere suggestion of running native auditing functions due to the poor performance and log management headaches that often come with auditing.What's with the stigma? And what kind of performance degradation given that database auditing is supposed to provide an accurate and complete source of information for a broad range of security and compliance requirements? In several series of performance tests I have conducted during the past four years, just turning on the audit decreased transactional throughput by 44 percent for an Oracle audit, 31 percent for IBM DB2, and 37 percent for SQL Server trace. This is not acceptable. And this decrease came just from creating the audit trail and doesn't include moving the data to an external analysis or reporting tool.

But once I tuned the process, the performance decrease was 6 percent for Oracle, 9 percent for DB2, and 4 percent for SQL Server.

How did I do this? By carefully selecting the right options at my disposal. Specifically, consider the following:

  • Different Audit Variants: Database vendors offer more than one way to collect audit data, and each variant has different performance characteristics. For example, DB2 event monitors performed worse than DBAudit, with increasing degradation as transaction rates increased.

  • Filtering: The more event types you want to collect, the more data the database must collect, assemble into an audit record, and then write. But you can direct SQL Server, for example, to only collect certain event types you need, often reducing total events to a fraction. By only collecting the events specific to your business need, you reduce processing overhead and disk I/O.

  • Audit Destinations: You can choose to keep audit data within the database, stored in a table, or write it externally. For example, with Oracle you can write to an internal audit table, write to disk files, and even stream the audit data as XML. Writing to external files is much faster.

  • Data Management and Clean-Up: If you process 1 million transactions, your audit log will contain 1 million or more rows. As the size of the data stored within the audit log grows, overhead increases. Try to purge audit records as fast as you can or move data to external platforms for analysis and reporting. You can write your own scripts to do this or leverage log management, system event management, or database activity monitoring products to assist.

In general, the relational database vendors know their customers rely on auditing to support compliance and security requirements, and they have greatly improved performance during the past four years. If you are smart with your setup, then auditing is no longer the performance nightmare it once was. Don't let a previous bad experience keep you from exploring database auditing as an option.

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
Comments
Newest First  |  Oldest First  |  Threaded View
Exploits Released for As-Yet Unpatched Critical Citrix Flaw
Jai Vijayan, Contributing Writer,  1/13/2020
Major Brazilian Bank Tests Homomorphic Encryption on Financial Data
Kelly Sheridan, Staff Editor, Dark Reading,  1/10/2020
Will This Be the Year of the Branded Cybercriminal?
Raveed Laeb, Product Manager at KELA,  1/13/2020
Register for Dark Reading Newsletters
White Papers
Video
Cartoon
Current Issue
The Year in Security: 2019
This Tech Digest provides a wrap up and overview of the year's top cybersecurity news stories. It was a year of new twists on old threats, with fears of another WannaCry-type worm and of a possible botnet army of Wi-Fi routers. But 2019 also underscored the risk of firmware and trusted security tools harboring dangerous holes that cybercriminals and nation-state hackers could readily abuse. Read more.
Flash Poll
[Just Released] How Enterprises are Attacking the Cybersecurity Problem
[Just Released] How Enterprises are Attacking the Cybersecurity Problem
Organizations have invested in a sweeping array of security technologies to address challenges associated with the growing number of cybersecurity attacks. However, the complexity involved in managing these technologies is emerging as a major problem. Read this report to find out what your peers biggest security challenges are and the technologies they are using to address them.
Twitter Feed
Dark Reading - Bug Report
Bug Report
Enterprise Vulnerabilities
From DHS/US-CERT's National Vulnerability Database
CVE-2019-3683
PUBLISHED: 2020-01-17
The keystone-json-assignment package in SUSE Openstack Cloud 8 before commit d7888c75505465490250c00cc0ef4bb1af662f9f every user listed in the /etc/keystone/user-project-map.json was assigned full "member" role access to every project. This allowed these users to access, modify, create and...
CVE-2019-3682
PUBLISHED: 2020-01-17
The docker-kubic package in SUSE CaaS Platform 3.0 before 17.09.1_ce-7.6.1 provided access to an insecure API locally on the Kubernetes master node.
CVE-2019-17361
PUBLISHED: 2020-01-17
In SaltStack Salt through 2019.2.0, the salt-api NEST API with the ssh client enabled is vulnerable to command injection. This allows an unauthenticated attacker with network access to the API endpoint to execute arbitrary code on the salt-api host.
CVE-2019-19142
PUBLISHED: 2020-01-17
Intelbras WRN240 devices do not require authentication to replace the firmware via a POST request to the incoming/Firmware.cfg URI.
CVE-2019-19801
PUBLISHED: 2020-01-17
In Gallagher Command Centre Server versions of v8.10 prior to v8.10.1134(MR4), v8.00 prior to v8.00.1161(MR5), v7.90 prior to v7.90.991(MR5), v7.80 prior to v7.80.960(MR2) and v7.70 or earlier, an unprivileged but authenticated user is able to perform a backup of the Command Centre databases.