Questions tagged [audit]

A set of processes or functionality that tracks changes to one or more components of a system, ensuring the completeness and accuracy of transaction processing, authorization, and validity of system operations.

Audit controls (in software development) are a series of procedures that track changes to systems or components of a larger system. The exact systems or components that are subject to audit are determined by the risk exposure of the overall system.

The most common types of audit controls are (see "Information technology audit" article on Wikipedia):

  • Data Capture Controls – ensures that all transactions are recorded in the application system, transactions are recorded only once, and rejected transactions are identified, controlled, corrected, and re-entered into the system.

  • Data Validation Controls – ensures that all transactions are properly valued.

  • Processing Controls – ensures the proper processing of transactions.

  • Output Controls – ensures that computer output is not distributed or displayed to unauthorized users.

  • Error Controls – ensures that errors are corrected and resubmitted to the application system at the correct point in processing.

Most of these controls are applied at the systems level. For example ACID compliant databases systems provide a level of data capture control.

You should tag your question with audit if you're asking about any of the following:

  1. Tracking changes to a system
  2. "Who did what" controls
  3. How to implement a "Maker-Checker" workflow

Questions related to general system logging of events and errors should not be tagged with audit.

1160 questions
28
votes
1 answer

Audit tables: Each field for table or one table

Everything is fine in my project except with the audit fields. Just insert and update is being audited in our imaginary universe. I proposed one table like similar to the next examples: best design for a changelog / auditing database…
razpeitia
  • 1,947
  • 4
  • 16
  • 36
28
votes
1 answer

Disable DELETE on table in PostgreSQL?

For a security sensitive design, I'd like to disable DELETEs on certain tables. The DELETE should merely set a deleted flag on a row (which would be then visible on a view, which would be used by the application layer). As I understand a rule would…
miku
  • 181,842
  • 47
  • 306
  • 310
28
votes
3 answers

How to get Java reflect to spot fields in the super class? not just the actual class

I've recently changed my schema a bit so my classes inherit from a super class, problem is my comparison method which generates an audit log, using Java reflect, is now only looping through the fields of the child class, not the superclass, is there…
williamsandonz
  • 15,864
  • 23
  • 100
  • 186
19
votes
1 answer

Hibernate Envers - Get Fields that have changed

I have a rather complicated DB structure that I am trying to audit. Currently I have Envers running and it audits the changes that are made to each object. This works really well! I now want to show some audit information on the UI. The…
RNJ
  • 15,272
  • 18
  • 86
  • 131
19
votes
6 answers

History tables pros, cons and gotchas - using triggers, sproc or at application level

I am currently playing around with the idea of having history tables for some of my tables in my database. Basically I have the main table and a copy of that table with a modified date and an action column to store what action was preformed e.g.,…
Nathan W
  • 54,475
  • 27
  • 99
  • 146
18
votes
3 answers

django AuditTrail vs Reversion

I am working on an new web app I need to store any changes in database to audit table(s). Purpose of such audit tables is that later on in a real physical audit we can asecertain what happened in a situation, who edited what and what was the state…
Anurag Uniyal
  • 85,954
  • 40
  • 175
  • 219
18
votes
4 answers

NPM configuration to skip vulnerabilities audit for devDependencies on install

Is it possible to configure npm to skip audit of vulnerabilities for devDependencies when running command npm install?
revy
  • 3,945
  • 7
  • 40
  • 85
17
votes
4 answers

Snapshot History With Entity Framework

I've been looking at some auditing hooks with Entity Framework. Many of them show old/new value comparisons. This does great for an audit trail but I'm looking to snapshot objects. For example... Let's say I have an application that manages…
RailRhoad
  • 2,128
  • 2
  • 25
  • 39
16
votes
5 answers

Business Audit log - recommended library or approach?

do you know any good Java library for audit logging? Or at least good book/article to help choose good approach to build audit log for an application? Library requirements: - define common audit metadata (userId, time, IP, ...) - define audit…
krtek
  • 1,055
  • 1
  • 13
  • 28
16
votes
1 answer

Keeping track of changed properties in JPA

Currently, I'm working on a Java EE project with some non-trivial requirements regarding persistence management. Changes to entities by users first need to be applied to some working copy before being validated, after which they are applied to the…
G_H
  • 11,739
  • 3
  • 38
  • 82
16
votes
3 answers

Can I use Spring Data JPA Auditing without the orm.xml file (using JavaConfig instead)?

I'm trying to get Spring Data Auditing to work in my Spring 3.2.8 / Spring Data 1.5 / Hibernate 4 project. As per the Spring Data Auditing docs, I've added the @CreatedBy, etc annotations to my entities, created by AuditorAware implementation, and…
Eric B.
  • 23,425
  • 50
  • 169
  • 316
15
votes
4 answers

What's the best tool for Javascript security auditing?

Something that can at least scan a batch of .js files looking for eval statements and other questionable code. Maybe just a regex pattern would do it, but I'd like to find a more sophisticated (and regularly maintained) tool.
mcqwerty
  • 3,386
  • 2
  • 25
  • 24
15
votes
6 answers

Data Auditing in NHibernate and SqlServer

I'm using NHibernate on a project and I need to do data auditing. I found this article on codeproject which discusses the IInterceptor interface. What is your preferred way of auditing data? Do you use database triggers? Do you use something…
Iain Holder
  • 14,172
  • 10
  • 66
  • 86
15
votes
4 answers

What's the best approach in auditing a big java/j2ee web application

I have to audit a large web Java/J2ee application that has evolved over several years. It's been written by some other company, not the one I'm working for. In it's current state it has become hard to evolve and maintain, new functionalities are…
Billy
  • 942
  • 5
  • 11
15
votes
1 answer

Why does Chrome audit recommend me to minimize cookie size?

How can I minimize cookie size of my requests? Chrome seems to 'warn me' about my cookie size being 41B, which is not a lot at all, but is there a reason it warns me about it? It is a PHPSESSID cookie, which I do not really know how to minimize. Any…
kingmaple
  • 4,200
  • 5
  • 32
  • 44
1
2
3
77 78