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
174
votes
6 answers

Database design for audit logging

Every time I need to design a new database I spend quite some time thinking on how I should set up the database schema to keep an audit log of the changes. Some questions have already been asked here about this, but I don't agree that there is a…
jbochi
  • 28,816
  • 16
  • 73
  • 90
126
votes
12 answers

is there a yarn alternative for npm audit?

need pinned resolution feature of yarn, but also want to audit with npm audit? Is there a yarn alternative to npm audit? Or, alternately, will pinning resolutions of dependencies of dependencies work in npm?
sjt003
  • 2,407
  • 5
  • 24
  • 39
125
votes
8 answers

Best design for a changelog / auditing database table?

I need to create a database table to store different changelog/auditing (when something was added, deleted, modified, etc). I don't need to store particularly detailed info, so I was thinking something along the lines of: id (for the event) user…
rcphq
  • 1,795
  • 3
  • 15
  • 13
110
votes
5 answers

See what process is accessing a file in Mac OS X

Note: This quesiton is NOT show me which files are in use. The file is not currently in use. The file will be in use at some unknown point in the future. At that point, I want to know what process accessed the file. I would like to be able to track…
JPC
  • 8,096
  • 22
  • 77
  • 110
73
votes
9 answers

Difference in Auditing and Logging?

I have been coming across these two words more often but i didn't see much difference in these? I mean want to know are they used interchangeably or there are some differences in those two? Thanks.
GuruKulki
  • 25,776
  • 50
  • 140
  • 201
59
votes
7 answers

MySQL auto-store datetime for each row

In MySQL, I'm sick of adding the columns dt_created and dt_modified (which are date time stamps for creation and last modified respectively) to all the tables I have in my database. Every time I INSERT or UPDATE the database, I will have to use the…
mauris
  • 42,982
  • 15
  • 99
  • 131
57
votes
7 answers

Counting the number of deleted rows in a SQL Server stored procedure

In SQL Server 2005, is there a way of deleting rows and being told how many were actually deleted? I could do a select count(*) with the same conditions, but I need this to be utterly trustworthy. My first guess was to use the @@ROWCOUNT…
Unsliced
  • 10,404
  • 8
  • 51
  • 81
55
votes
5 answers

Ideas on database design for capturing audit trails

How can I maintain a log of the data in my DB? I have to maintain a log of every change made to each row. That means that I can't allow DELETE and UPDATE to be performed. How can I keep such a log?
Greens
  • 3,061
  • 11
  • 43
  • 61
54
votes
3 answers

Entity Framework 6: audit/track changes

I have my core project in C#. I work on a database, where some tables have the columns "user_mod" and "date_mod" for sign who and when made some mods and the same with "data_new" and "user_new". My question: is there a way to centralize this and…
Piero Alberto
  • 3,823
  • 6
  • 56
  • 108
44
votes
2 answers

npm audit only for production dependencies?

Currently, when running npm audit in a project, it checks both the dependencies and the devDependencies. I am looking for a way to only check the dependencies. Is there currently a way to do so?
user857990
  • 1,140
  • 3
  • 14
  • 29
41
votes
3 answers

Chrome devtools audits tab does not show

My version of google chrome is 83.0.4103.116 (Build oficial) (64 bits) (cohort: Stable) But audits tab does not show on devtools. Any idea of how enable audit tab?
Byron2017
  • 871
  • 2
  • 11
  • 23
34
votes
10 answers

Creating audit triggers in SQL Server

I need to implement change tracking on two tables in my SQL Server 2005 database. I need to audit additions, deletions, updates (with detail on what was updated). I was planning on using a trigger to do this, but it seams that this is easy to do…
Mike Cole
  • 14,474
  • 28
  • 114
  • 194
32
votes
3 answers

Implementing Audit Log / Change History with MVC & Entity Framework

I am building in a Change History / Audit Log to my MVC app which is using the Entity Framework. So specifically in the edit method public ActionResult Edit(ViewModel vm), we find the object we are trying to update, and then use…
baron
  • 11,011
  • 20
  • 54
  • 88
32
votes
4 answers

Should I use PUT method for update, if I also update a timestamp attribute

According to REST style, it's generally assumed that HTTP POST, GET, PUT, and DELETE methods should be used for CREATE, READ, UPDATE and DELETE (CRUD) operations. But if we stick to the HTTP method definitions, it might not be so clear. In this…
opensas
  • 60,462
  • 79
  • 252
  • 386
32
votes
6 answers

Suggestions for implementing audit tables in SQL Server?

One simple method I've used in the past is basically just creating a second table whose structure mirrors the one I want to audit, and then create an update/delete trigger on the main table. Before a record is updated/deleted, the current state is…
Brandon Wood
  • 5,347
  • 4
  • 38
  • 31
1
2 3
77 78