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
7
votes
3 answers

How would I use an audit trail to display which fields have ever been edited?

For a project I am working on, I have been asked to create an audit trail of all changes that have been made to records. This is the first time I have had to create an audit trail, so I have been doing a lot of research on the subject. The…
Kirsehn
  • 215
  • 4
  • 10
6
votes
4 answers

How to Audit Database Activity without Performance and Scalability Issues?

I have a need to do auditing all database activity regardless of whether it came from application or someone issuing some sql via other means. So the auditing must be done at the database level. The database in question is Oracle. I looked at doing…
amitm
  • 153
  • 1
  • 6
6
votes
3 answers

Can't create Policy: 'no matches for kind "Policy"'

I am following the instructions here on how to create a policy to audit actions in Kubernetes. When I run the following YAML file: kubectl apply -f - <
E235
  • 11,560
  • 24
  • 91
  • 141
6
votes
3 answers

Ideas, Tips, Tools, Framework for implementing Audit

I'm looking for Ideas, Tips, Existing Frameworks (based on .NET), Tools and also your experience on what's the best way to implement a good Audit Trail. Our typical Applications are nothing fancy ASP.NET MVC 3- Security Layer - Business Layer -…
gsharp
  • 27,557
  • 22
  • 88
  • 134
6
votes
5 answers

Prevent audit table tampering

We have audit table in our database. Records to this table are done using triggers. Currently, there is nothing that prevents user to log on to database server, open table from management studio and change data in audit table. What are possible…
buhtla
  • 2,819
  • 4
  • 25
  • 38
6
votes
10 answers

What reporting is available for svn?

We are in the process of moving to SVN. Unfortunately for us, we are audited periodically, where the auditors require information like: Histories of changes to files History of access to SVN New files Added Changes in files Is there a tool which…
Bravax
  • 10,453
  • 7
  • 40
  • 68
6
votes
2 answers

Audit many-to-many relationship in NHibernate

I have implemented listeners to audit changes to tables in my application using IPreUpdateEventListener and IPreInsertEventListener and everything works except for my many-to-many relationships that don't have additional data in the joining table…
Kendrick
  • 3,747
  • 1
  • 23
  • 41
6
votes
1 answer

Implementing efficient audit trail of record changes in Google App Engine - design patterns

I have a quite common design problem: I need to implement a history log (audit trail) for records in Google App Engine. The history log has to be structured, i.e I cannot join all changes into some free-form text and store in string field. I've…
Alek Kowalczyk
  • 710
  • 6
  • 21
6
votes
3 answers

Trigger for insert, update, delete

I want to insert rows into the audit table whenever an insert, update or delete takes place in the master table "Table1" - doesn't matter which column is changed/inserted. I also want to add I, U or D on insert, update or delete. For insert and…
Tech Xie
  • 927
  • 4
  • 12
  • 24
6
votes
4 answers

Is there an elegant way to track the modification of all columns of one table in SQL Server 2008

There is a table in my database containing 100 columns. I want to create a trigger to audit the modification for every update operation. What I can think is to create the update clause for all columns but they are all similar scripts. So is there…
zs2020
  • 53,766
  • 29
  • 154
  • 219
6
votes
1 answer

Ways to pass additional data to Custom RevisionEntity in Hibernate Envers?

It's RESTful web app. I am using Hibernate Envers to store historical data. Along with revision number and timestamp, I also need to store other details (for example: IP address and authenticated user). Envers provides multiple ways to have a custom…
Anmol Gupta
  • 2,797
  • 9
  • 27
  • 43
6
votes
2 answers

Entity Framework 7 audit log

I am porting an old project over to ASP.NET 5 and Entity Framework 7. I have used the database first approach (DNX scaffold) to create the model. The old project is based on Entity Framework 4 and audit tracking is implemented by overriding the…
Stian Sandve
  • 520
  • 4
  • 13
6
votes
2 answers

Tracking who makes changes to SQL Server within C# application or SQL Server

I'm converting an application from Access to SQL Server 2014. One of the capabilities of this tool is to allow users to create ad-hoc SQL queries to modify delete or add data to a number of tables. Right now in Access there is no tracking of who…
Spots Knight
  • 136
  • 4
  • 14
6
votes
4 answers

How should I audit changes in a MySQL table (using MySQL 4)?

I have been asked to audit any/all changes in a MySQL table. Does anyone know of any tools out there to help me do this or do I need to write my own solution? If I write my own audting, my initial thought it to make a separate table and build a…
Haabda
  • 1,413
  • 2
  • 13
  • 17
6
votes
1 answer

Trigger to raise error, prevent delete, and audit attempt

I'm attempting to create a trigger which does three things: 1. Prevents the deletion of data on a particular table 2. Generates an error message for the user 3. Logs the data which was attempted to be deleted along with session information from…
cninsd
  • 152
  • 3
  • 7