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

Building a snapshot table from audit records

I have a Customer table with the following structure. CustomerId Name Address Phone 1 Joe 123 Main NULL I also have an Audit table that tracks changes to the Customer table. Id Entity EntityId Field OldValue NewValue…
Thracian
  • 651
  • 4
  • 8
  • 24
2
votes
0 answers

Manage Audit Triggers in PostgreSQL 9.3

We have implemented a browser-based system that is run from a PostgreSQL 9.3 database. We have hit a snag in addressing auditing. Is there a way to record if an audit trigger has been turned off. This question is directly related to having checks…
Donald Singh
  • 21
  • 2
2
votes
1 answer

Telerik Open access Audit Trail

How can i best implement an audit trail for an application that uses Telerik open access. I have posted this question on their support but there has been no reply for days (sucks) I have already tried the Tracking events within each scope but am…
user437329
2
votes
2 answers

How to represent successful, failed login and logout events

We have an audit requirement where we need to track user activity (e.g. successful login, logout actions and failed logins). We have defined 3 event types to track this information. What would be a nice way to show these violations (e.g. failed…
user339108
  • 12,613
  • 33
  • 81
  • 112
2
votes
1 answer

Can you configure SQL Server 2008 Auditing to keep the audit data on a database other than the one being audited?

We are planning on using the new auditing feature in SQL Server 2008. Is there a way to configure the auditing component to insert audit data to a separate database?
Saturn K
  • 2,705
  • 4
  • 26
  • 38
2
votes
1 answer

How would you audit ASP.NET Membership tables, while recording what user made the changes?

Using a trigger-based approach to audit logging, I am recording the history of changes made to tables in the database. The approach I'm using (with a static sql server login) to record which user made the change involves running a stored procedure…
Pete
  • 1,790
  • 2
  • 19
  • 31
2
votes
2 answers

Dynamically constructing MySQL Code for creating a trigger

I am trying to implement audit trail/logging for a MySQL database. Now I have created an "audit" db (let's call it company_audit) which will contain "audit" copies of certain tables in the main db. (Say for company.customers I will create…
Ifedi Okonkwo
  • 3,406
  • 4
  • 33
  • 45
2
votes
2 answers

How to detect what control triggers BeforeUpdate event in Access 2007

I have an audit trail that uses the BeforeUpdate event to track changes made on a subform using the following code: `Dim USR As String Dim TS As Date Dim Connection As ADODB.Connection Dim RecordSet As ADODB.RecordSet Dim Ctl As Control MsgBox…
110SidedHexagon
  • 555
  • 2
  • 14
  • 37
2
votes
0 answers

Audit trail is not purged

I try to clean audit trail (my database version is 11.2.0.3.0). Everything run without errors, but audit trail is not purged. Here is what I do: 1) cleanup inicialization BEGIN IF NOT…
user3682425
  • 21
  • 1
  • 5
2
votes
2 answers

EF 6 OriginalValues lost when using Attach method

I have the following Update generic method for my entities: public void Update < T > (T entity) where T: class { DbEntityEntry dbEntityEntry = DbContext.Entry(entity); if (dbEntityEntry.State == System.Data.Entity.EntityState.Detached) { …
VAAA
  • 14,531
  • 28
  • 130
  • 253
2
votes
4 answers

Compare deleted and inserted table in SQL Server 2008

I am new to SQL Server 2008 and I need advice from all of you. I want to find out the changed value in inserted and deleted tables of the SQL Server 2008 for a table because I am currently doing the audit trail to keep the old and new value. How can…
user3387045
  • 31
  • 1
  • 1
  • 3
2
votes
1 answer

In yii how to i use audit trail in log in/sign in?

I'm developing now a yii application. I've already use audit trail for logging my model regarding add, edit, delete. But how i can log the login/signin portion into my database using audit trail?
jttorate
  • 61
  • 1
  • 1
  • 9
2
votes
5 answers

Audit trail in hibernate with new and old values using an Interceptor

I can easily log last modified date, modified by etc. However, I need old and new value to be logged too. In the interceptor, I can fire a select before postflush starts executing to get the value of the current record. Then I can run a diff between…
Mak
  • 205
  • 1
  • 4
  • 8
2
votes
1 answer

Storage of auditable fields per entity

I guess it's a good practice to capture auditable fields to track what happened to a particular entity (say createdBy, creationDate, modifiedBy, modifiedDate) I am assuming if an object is never modified it makes sense just to capture the following…
Joe
  • 14,513
  • 28
  • 82
  • 144