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
4
votes
1 answer

Storing user_id in the paper_trail versions table

I am using paper trail to audit changes to data and would like to store the user_id of the current user in addition to the "whodunnit" column that paper_trail stores by default. I had no trouble modifying the versions migration to add the user_id…
snowguy
  • 899
  • 2
  • 13
  • 23
4
votes
1 answer

Audit trails and implementing HIPAA best practices

Are there any best practices for audit trail implementation for HIPPA starting with database design.
Greens
  • 3,061
  • 11
  • 43
  • 61
3
votes
0 answers

Track user activity in Dash application

I have deployed a dash app to a computer (to act as a server) for which people in my company can access it if they're connected to the company network. I am also going to apply the basic dash-auth. Is there anyway to track the IP address, username,…
DataNoob7
  • 191
  • 1
  • 8
3
votes
0 answers

Program Name in audit fields

Hey hoping someone can assist or at least point me in the right direction. I'm looking to add some Generate always audit fields into some of our new tables to assist in the auditing process, from what i have found only special registers can be used…
Michael Knight
  • 31
  • 3
3
votes
1 answer

How do I target another database with Audit.Net - Audit.EntityFramework.Core

I'm trying to implement the Audit.EntityFramework.Core package from the Audit.Net repository but am running into some difficulty. I'm unable to save changes or target a different database. I've modified my SaveChanges and SaveChangesAsync function…
Josh
  • 2,422
  • 2
  • 27
  • 18
3
votes
2 answers

Does Cloud Firestore have an audit trail?

I really like the offering that's Cloud Firestore. But does it have an audit trail? Why am I asking? While some use of databases is essentially "state" (e.g. multiplayer games), for other uses also the history matters. Also, at times being able to…
akauppi
  • 17,018
  • 15
  • 95
  • 120
3
votes
3 answers

How to retrieve an audit trail across two SQL Server tables and put them back in the right order?

Background Context: i have a database table called Project and a table called ProjectHistory with the same schema. I am using nhibernate so i also have a domain object called Project and a domain object called ProjectHistory (which derived from…
leora
  • 188,729
  • 360
  • 878
  • 1,366
3
votes
3 answers

Keep only the last 5 rows per object in an audit table

I have a web application backed by a Postgres (v11) database and a main table where each row in the table may be seen as an object and each column is a field of the object. So we have: | id | name | field1 | field2| .... | field…
navinpai
  • 955
  • 11
  • 33
3
votes
1 answer

Does CosmosDB have an inherent way to log CRUD requests?

I'm trying to find out if CosmosDB has any built-in functionality that can be used as an audit log, i.e. one of the existing Azure diagnostic/monitoring functionality logs out specific changes to the database, including the JSON data written. Does…
dlanod
  • 8,664
  • 8
  • 54
  • 96
3
votes
0 answers

Ef Core - auditing changes and including navigation properties

We need to implement a comprehensive audit log of changes for an aggregate entity called Project, where users can see what changed with each save and the before and after values of those changes. The entity contains a few child collections (for…
Amay
  • 106
  • 7
3
votes
1 answer

Oracle 11g audit trail for specific tables

I would like to submit a question about creating an audit trail for specific tables on Oracle 11g database. We would like to track user's changes, on some specific tables, that records has been changed from the application (front end) side. Of…
DoeUS
  • 113
  • 13
3
votes
0 answers

Custom Auditing EF6.2 with DbContext not detecting modifications

I have extended the DbContext to enable auditing and I'm facing an issue when I have modifications because of the collection object I'm using to track reports no modifications and also, for a new record, I'm not getting the Primary Key: public…
DoomerDGR8
  • 4,840
  • 6
  • 43
  • 91
3
votes
1 answer

How to add a second foreign key to an EF property which is part of a composite foreign key already

I am trying to create an audit trail for a table by creating a duplicate of that table which includes an extra date as part of the primary key. Here is a simplified example of what I want to do. My code for the entities is currently as…
hobwell
  • 538
  • 1
  • 8
  • 26
3
votes
1 answer

Audit windows activity of user on WinFormApplication

I need to implement Audit Trail in my application which is WinForm application. I need to log all the activity done by user on application and in System to see if he had changed any security settings or anything. Is there any way to do this by AOP…
XYZ
  • 119
  • 1
  • 12
3
votes
1 answer

Capturing audit trail information via REST

I'm struggling with coming up with the "right" way to capture audit information via a REST service. Let's say I've got an internal REST API for an Employee resource. I want to capture things when an Employee is added/modified/removed such as the…
IceBox13
  • 1,338
  • 1
  • 14
  • 21
1 2
3
…
19 20