Stack Overflow
Stack Overflow

Questions tagged [auditing]

330 questions
205
votes
12 answers

How to version control a record in a database

Let's say that I have a record in the database and that both admin and normal users can do updates. Can anyone suggest a good approach/architecture on how to version control every change in this table so it's possible to roll back a record to a…
Niels Bosma
  • 11,758
  • 29
  • 89
  • 148
58
votes
8 answers

Finding property differences between two C# objects

The project I'm working on needs some simple audit logging for when a user changes their email, billing address, etc. The objects we're working with are coming from different sources, one a WCF service, the other a web service. I've implemented the…
Pete Nelson
  • 1,328
  • 1
  • 13
  • 23
45
votes
9 answers

Versioning Database Persisted Objects, How would you?

(Not related to versioning the database schema) Applications that interfaces with databases often have domain objects that are composed with data from many tables. Suppose the application were to support versioning, in the sense of CVS, for these…
Chris Vest
  • 8,642
  • 3
  • 35
  • 43
33
votes
5 answers

How can I use a PostgreSQL triggers to store changes (SQL statements and row changes)

Using PostgreSQL triggers, is it possible to record the changes that have happened to a table due to INSERT or UPDATE SQL statements and log them to a file for later execution. This is only to be used temporally so just something quick and dirty…
jDempster
  • 503
  • 1
  • 4
  • 7
26
votes
5 answers

Exploitable Python Functions

This question is similar to Exploitable PHP Functions. Tainted data comes from the user, or more specifically an attacker. When a tainted variable reaches a sink function, then you have a vulnerability. For instance a function that executes a…
rook
  • 66,304
  • 38
  • 162
  • 239
17
votes
5 answers

Rails audit system with both ActiveResource and ActiveRecord

I have a huge project with both of ActiveRecord and ActiveResource models. I need to implement logging of user activity with these models and also to log changes of model attributes (save object state or somthing like that). Changes can made by…
Fivell
  • 11,829
  • 3
  • 61
  • 99
17
votes
3 answers

How to manage object revisions in Grails?

I need to implement a revision system for articles in my grails web app. After searching grails forum, stackoverflow, grails plugins and googling internet, I have ended up with 3 options: Option 1 - Using the grails Envers plugin (see…
fabien7474
  • 16,300
  • 22
  • 96
  • 124
11
votes
2 answers

Javers - What are advantages of using Javers instead of Envers?

I am developing a RESTful API using Spring Data REST. Now for auditing, Spring does have the option to auditing meta data like created_date and modified_date but they don't provide entity versioning. Currently there are two popular libraries for…
Charlie
  • 3,113
  • 3
  • 38
  • 60
11
votes
2 answers

Entity Framework - Auditing activity

My database has a 'LastModifiedUser' column on every table in which I intend to collect the logged in user from an application who makes a change. I am not talking about the database user so essentially this is just a string on each entity. I…
Biggle10
  • 161
  • 1
  • 6
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
9
votes
6 answers

SQL Server 2008 Change Data Capture, who made the change?

I asked a question on SOF a week or so ago about auditing SQL data changes. The usual stuff about using triggers came up, there was also the mention of CDC in SQL Server 2008. I've been trying it out today and so far so good, the one thing I can't…
MrEdmundo
  • 5,105
  • 13
  • 46
  • 58
9
votes
0 answers

How to enable JPA auditing with SpringBootTest?

I want to write integration tests for my RestAPI endpoints, and I'm struggling with @EnableJpaAuditing. I want some of my entities to be audited by Spring, so I've created the following configuration class: @Configuration @EnableJpaAuditing public…
Serg Derbst
  • 444
  • 6
  • 18
9
votes
3 answers

Spring Data JPA Auditing not working for the JpaRepository update method with @Modifying annotation, why?

I am working on Spring Data JPA and Postgres example. In this example, I've implemented Auditing by following link: https://www.baeldung.com/database-auditing-jpa and Spring Boot JPA@CreatedDate @LastModifiedDate not being populated when saving the…
PAA
  • 1
  • 46
  • 174
  • 282
8
votes
1 answer

Spring Data fills @LastModifiedDate by not @CreatedDate

I have following Spring Boot sample application. The crazy thing is if I add @EnableMongoAuditing annotation on SampleApplication bean, lastModifiedDate would be filled by createDate would not. Why is that? I searched the web and many people had…
Amir Pashazadeh
  • 7,170
  • 3
  • 39
  • 69
8
votes
0 answers

Using "Microsoft Windows Security Auditing" provider in real-time consumer with ETW (Event Tracing for Windows)

My task is to make an ETW real-time consumer with events provided by 'Microsoft Windows Security Auditing'. I made a simple controller and consumer application, basing on this example…
user4410709
1
2 3
…
21 22