Questions tagged [auditing]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
192votes
12answers
86kviews

How to version control a record in a database [closed]

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 ...
user avatar
  • 11.4k
58votes
8answers
29kviews

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 ...
user avatar
  • 1,328
42votes
9answers
9kviews

Versioning Database Persisted Objects, How would you? [closed]

(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 ...
user avatar
  • 8,502
28votes
5answers
27kviews

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 ...
user avatar
  • 453
26votes
5answers
10kviews

Exploitable Python Functions [closed]

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 ...
user avatar
  • 64.4k
17votes
6answers
4kviews

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 ...
user avatar
  • 11.5k
17votes
3answers
2kviews

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 - ...
user avatar
  • 15.9k
11votes
2answers
7kviews

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 ...
user avatar
  • 161
10votes
3answers
941views

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 ...
user avatar
  • 16.4k
9votes
6answers
14kviews

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 ...
user avatar
  • 4,995
8votes
1answer
12kviews

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 ...
user avatar
7votes
3answers
14kviews

How to enable auditing for MongoDB via Annotations in Spring

I wanted to enable some auditing features, such as @CreatedDate. I am not using Spring xml configuration file, so I cannot add mongo:auditing to Spring configuration. I was wondering if there was an ...
user avatar
  • 789
7votes
2answers
6kviews

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. ...
user avatar
  • 2,362
7votes
4answers
2kviews

When to update audit fields? DDD

I have a Meeting Object: Meeting{id, name, time, CreatedBy, UpdatedBy} and a MeetingAssignee{id, MeetingID, EmployeeId, CreatedBy, UpdatedBy) Meeting, as Aggregate root, has a method ...
user avatar
7votes
3answers
2kviews

How to store audit data in Azure

We're in the design phase for building an audit trail in an existing web application. The application runs on Windows Azure and uses a SQL Azure database. The audit logs must be filtered by user, or ...
user avatar
  • 987
7votes
0answers
2kviews

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 http://msdn....
user avatar
6votes
2answers
10kviews

How to use Auditing in JPA/Spring-Data JPA?

I am using JPA & Spring-Data JPA in a project. I have one table wherei Insert and then update the data. However i need the auditing information to save the state of all the objects i.e. I need ...
user avatar
  • 1,021
6votes
1answer
4kviews

How to track online users in Rails?

This was always a problem for me, as rails doesn't have some mechanisms for session tracking like java frameworks do, what methods do you use to track who is currently logged on your site? I use a ...
user avatar
  • 63
6votes
1answer
2kviews

Getting modified properties by revision

I am using Hibernate Envers to audit my entities and properties (org.hibernate.envers.global_with_modified_flag=true). This seems to work, but now I'd like to get all properties of a specific entity ...
user avatar
5votes
3answers
27kviews

Nmap not retrieving MAC address and Vendor

I've found a strange behaviour in Nmap (I am using version 5.51 if that matters but I have the same issue with version 5.00), on some networks this plugin does not retrieve MAC address and, ...
user avatar
  • 2,971
5votes
3answers
7kviews

SQL Azure Database. Login with non-secure connection string

I have an SQL Azure database and have the auditing enabled on it. According to the portal , Auditing requires use of Security Enabled Connection Strings and consequently have set the Security Enabled ...
user avatar
5votes
1answer
2kviews

ORIGINAL_LOGIN and SYSTEM_USER functions for auditing?

I am implementing an inserted trigger and am considering using ORIGINAL_LOGIN function to capture the current executing user. I would like to know the pros and cons of using ORIGINAL_LOGIN for ...
user avatar
  • 4,846
5votes
1answer
7kviews

spring jpa auditing lastmodifiedby and lastmodifiedDate are ok, but createdBy and createdDate annotation are always null [duplicate]

I'm trying to setup (as a java beginner) spring jpa auditing for hours/days now ... and I'm starting to get very frustrating as I can't find the problem. I would really appreciate some help. @...
user avatar
  • 163
5votes
1answer
18kviews

"audit create session by session" vs. "audit create session by access"?

When I enabling auditing for create session by the following way: audit create session by session; Then I am querying the following: select * from dba_priv_audit_opts; The result is: USERNAME | ...
user avatar
  • 1,821
5votes
2answers
3kviews

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 @...
user avatar
  • 8,662
5votes
1answer
1kviews

Auditing with Envers and Hibernate Spatial 4

I'm attempting to use Envers to set up Auditing on my Hibernate entities. However, I'm getting the error: Could not determine type for: geometry, at table: Location_AUD, for columns: [org.hibernate....
user avatar
  • 100
5votes
4answers
3kviews

Audit and data history in java

I have a set of domain objects and its related tables for application's configurations. Authenticated users can change these domain objects data thru a presentation layer. These domain objects have ...
user avatar
  • 6,380
5votes
0answers
3kviews

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 ...
user avatar
5votes
1answer
2kviews

JPA Auditing with Kotlin

I want to use the @CreatedDate annotation in a kotlin data class. All attributes should be initialized as immutable (val). The problem is, that the implementation is not able to handle immutable ...
user avatar
4votes
3answers
18kviews

Spring JPA Auditing empty createdBy

I am using the auditing capabilities of Spring Data and have a class similar to this: @Entity @Audited @EntityListeners(AuditingEntityListener.class) @Table(name="Student") public class Student { ...
user avatar
  • 14.4k
4votes
4answers
9kviews

Logging in a Winform application

Initial situation: There is a big Winform application with many dialogs and an Oracle database in the background. Now there is the requirement to implement a audit logging feature, which logs data ...
user avatar
  • 1,602
4votes
2answers
2kviews

Oracle audit grant dba role

Running Oracle 11gR1 in an XP SP2 virtual machine. Full disclosure: This is for an assignment. I'm attempting to audit whenever a user is granted the DBA role and fire off an email when the event ...
user avatar
  • 41
4votes
1answer
1kviews

Pass object between two Around functions - AOP

I am doing Auditing for my Controller, Service and Dao layer. I have three Around aspect functions for Controller, Service and Dao respectively. I use a custom annotation which if present on the ...
user avatar
4votes
1answer
1kviews

How to change the "Applies To" field under folder auditing options programatically (.NET)

I am trying to set the "Applies To" field under folder auditing options programatically. In MSDN, the code example there uses the FileSystemAuditRule class to add a new audit rule to a folder. There ...
user avatar
  • 6,040
4votes
2answers
866views

Is there a good framework or library for auditing LDAP/Security management behavior in Java?

I asked a similar question earlier, and this is an extension to it. Basically, we need to have auditable logs for legal reasons of permission/user management and authentication attempts. Our ...
user avatar
  • 12.4k
4votes
1answer
821views

Hibernate Envers for Doctrine?

Doctrine 1.x and 2 both offer some kind of Versionable support in the form of a separate auditing table that tracks changes over time. However, the versions appear to be intended for per-row use (ie, ...
user avatar
4votes
4answers
3kviews

Complex NHibernate Auditing

I'm using the IPostUpdateEventListener interface to do update audit logging now, grabbing the old and new values, then storing each updated field in an "Audit" table and all that jive. Works swell, ...
user avatar
4votes
4answers
3kviews

How should I track changes on any object in asp.net mvc (nhibernate)?

I am looking for a good way to track down every change that is made on an object. We are building a custom framework and we need to have a history (kind of) about who changed which object when and ...
user avatar
  • 650
4votes
1answer
823views

LocalDateTime and JodaDate conflicts

I'm creating a multi module Maven project using spring MVC, hibernate, Spring Data JPA project. Currently I have integrated an Activiti workflow engine and using Joda date dependency. But my model ...
user avatar
4votes
1answer
223views

Trigger not able to initialise variable

I have trigger for auditing, which stored the action performed on any row of EMP table. This trigger works fine, except in some cases (which occurs very rarely, and I cannot identify exact condition)...
user avatar
  • 1,067
4votes
0answers
846views

Spring trying to set audit fields on null object

Spring-data-mongodb is trying to add createdDate to a null object and fails to do so. How do I configure spring audit to ignore null objects so it does not try to add audit fields to it? I have an ...
user avatar
4votes
2answers
754views

How do I do backup and (point-in-time) recovery for etcd?

I understand that etcd stores its data in some kind of distributed log. Are there tools to back up these logs and do recovery from them? Does that also support point-in-time recovery (and how far ...
user avatar
  • 249k
3votes
3answers
13kviews

Spring Data JPA and Spring Boot auditing with Hibernate Envers

I am using Spring Data JPA and Spring Boot for my project. I have Audit requirement for Objects(Create/Update/Delete). I may need to get Audit revisions for particular objects too. I have checked on ...
user avatar
  • 305
3votes
2answers
2kviews

Auditing in Oracle

I need some help in auditing in Oracle. We have a database with many tables and we want to be able to audit every change made to any table in any field. So the things we want to have in this ...
user avatar
3votes
3answers
195views

Best way of recording activity from a user in the database?

I am building an application that perform checks on users on specific days. I need to keep track of how many times these checks are performed against that particular user. My initial thought was to ...
user avatar
  • 77.4k
3votes
2answers
2kviews

Is there a way to bypass AuditingEntityListener to set up data for a test?

We've got a Spring project that is using the AuditingEntityListener on our JPA entities: @EntityListeners(AuditingEntityListener.class) Our base entity has a lastModifiedDate defined as: @Column(...
user avatar
3votes
1answer
2kviews

Auditing an Oracle constraint violation?

Can I audit an Oracle constraint violation? I created a constraint in a table and I want to audit it when some process violates this constraint. Is this possible? How can I do it? I'm using Oracle ...
user avatar
  • 45
3votes
2answers
280views

What security events does one audit for a line of business application?

I already audit authorization success, failure and logout. I've considered auditing (logging) every method call and keeping a version of every row and column that was ever modified, but both of those ...
user avatar
3votes
1answer
2kviews

MappedSuperclass Alternatives in Grails

In many past projects, I used this JPA / Hibernate approach to add auditing capabilities to a system. It's very effective and unobtrusive. Is there a Grails @MappedSuperclass alternative (short of ...
user avatar
  • 4,623
3votes
2answers
2kviews

Audit Triggers: Use INSERTED or DELETED system tables

The topic of how to audit tables has recently sprung up in our discussions... so I like your opinion on whats the best way to approach this. We have a mix of both the approaches (which is not good) in ...
user avatar
  • 367

15 30 50 per page
1
2 3 4 5
7