Stack Overflow
Stack Overflow

Questions tagged [audit-trail]

An audit trail (also called audit log) is a security-relevant chronological record, set of records, and/or destination and source of records that provide documentary evidence of the sequence of activities that have affected at any time a specific operation, procedure, or event.

296 questions
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
36
votes
9 answers

Maintaining Referential Integrity - Good or Bad?

We are planning on introducing simple Audit Trail in our database using triggers and separate history table for each table that requires auditing. For example consider table StudentScore, it has few foreign keys (eg. StudentID, CourseID) linking it…
YetAnotherUser
  • 9,156
  • 3
  • 39
  • 53
28
votes
4 answers

Log User Activity on ASP.NET MVC Application

Is there A good strategy to Log the User activity on an ASP MVC App? (ActionFilters/ HTTPModules). Something like last user activity (just like StackOverflow "Seen 23 mins ago"), and even what Pages and Controllers were used, and pushing even…
JOBG
  • 4,544
  • 4
  • 26
  • 47
26
votes
6 answers

Effective strategy for leaving an audit trail/change history for DB applications?

What are some strategies that people have had success with for maintaining a change history for data in a fairly complex database. One of the applications that I frequently use and develop for could really benefit from a more comprehensive way of…
Dana the Sane
  • 14,762
  • 8
  • 58
  • 80
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

Audit Trail in web application using sql server

We are developing a web application using asp.net and sql server. We are required to do an Audit trail for the application. As I understand this, an audit trail would basically be for all the Inserts, Updates and Deletes on the data base right? Now…
xeshu
  • 788
  • 2
  • 11
  • 24
17
votes
1 answer

How to log data change in postgresql?

This question may seem to be a possible duplicate of some other questions that are related to this topic. I've found some similar questions(some questions were asked years back and discussion on the topic seemed to be almost over). But no feasible…
harry
  • 1,410
  • 3
  • 12
  • 31
16
votes
4 answers

What are good NoSQL and non-relational database solutions for audit/logging database

What would be suitable database for following? I am especially interested about your experiences with non-relational NoSQL systems. Are they any good for this kind of usage, which system you have used and would recommend, or should I go with normal…
Juha Syrjälä
  • 33,425
  • 31
  • 131
  • 183
12
votes
3 answers

What do you think of this approach for logging changes in mysql and have some kind of audit trail

I've been reading through several topics now and did some research about logging changes to a mysql table. First let me explain my situation: I've a ticket system with a table: 'ticket' As of now I've created triggers which will enter a duplicate…
floGalen
  • 262
  • 2
  • 17
11
votes
1 answer

Change Data Capture or Change Tracking - Same as Traditional Audit Trail Table?

Before I delve into the abyss of Microsoft documentation any deeper, I'd like to know if someone experienced with Change Data Capture and Change Tracking know if one or both of these can be used to replace the traditional ... "Audit trail table…
HardCode
  • 6,497
  • 4
  • 31
  • 54
11
votes
2 answers

Firebird - get all modified fields inside a trigger

I need to get all the values which changed in a row and post modifications on other 'audit' table. Can I accomplish this, without writing the conditions for each element from the row? I know the SQL from http://www.firebirdfaq.org/faq133/ which…
RBA
  • 12,337
  • 16
  • 79
  • 126
10
votes
3 answers

How to implement context based DB auditing?

I have a current DB driven application which has several methods for accessing data. Web Application Direct SQL Access users (I'm trying to remove these) Client Server application Batch inputs and outputs I need to implement context based auditing…
Ollie
  • 17,058
  • 7
  • 48
  • 59
10
votes
5 answers

How to create Triggers to add the change events into Audit Log tables

Suppose we have 50 tables in a database and we want to capture all the changes (Previous value and new value of columns) across the columns of each table. An audit table will be there, which will have below columns: ID, Server_Name, User_Name,…
user2160151
  • 103
  • 1
  • 1
  • 4
9
votes
1 answer

how to build audit trails in rails app

I have a small rails app. I want to put audit trail in it. Basically when a new user is added. it will insert a row in AuditTrailUsers table with the new user_id created and logged in users' user_id. I am thinking about using rails callback…
groovynoob
  • 343
  • 1
  • 3
  • 8
8
votes
4 answers

How to create audit trail or logging tables with triggers in MySQL

I want a trigger that triggers whenever the loan table is updated (i.e. a book is returned). It should take values from the rows in the loan table only where the loan is overdue and insert them into a new table. the 'loan' table: CREATE TABLE loan…
DinosaurHunter
  • 652
  • 2
  • 9
  • 23
1
2 3
…
19 20