Stack Overflow
Stack Overflow

Questions tagged [audit-tables]

73 questions
1
vote
1 answer

make sure audit table doesn't affect RAM used by application

I tried to simplify my situation as much as possible, so it doesn't look too real, sorry. But it is based on a real concern. Let's imagine I have a small Android application that is showing user the current temperature. The temperature is changing…
Alek86
  • 1,489
  • 3
  • 17
  • 26
1
vote
1 answer

Comparing values between two rows of data and only showing the columns that are different

In a previous application version we were using a particular field for a primary key, but because the field may represent different identities across various systems we have made it a non significant field(ie not a primary key or part of a composite…
ecathell
  • 1,030
  • 13
  • 25
1
vote
1 answer

SQL Server - Rolling back particular transaction only at a later date

I have SQL Server 2014, standard edition. We have several tables where we delete data from, then re-insert it under different primary keys (to merge records for two people in our system that are actually the same). All these changes are performed…
Andy
  • 1,243
  • 3
  • 22
  • 40
1
vote
0 answers

how to capture old and new column values with Oracle Fine-Grained Auditing (FGA)

In answers to this (old) question Auditing in Oracle, it's claimed that Fine-Grained Auditing (FGA) can support the capture of both old and new column values. However, there's no specific guidance about doing so. I've read the FGA documentation and…
kingolego
  • 145
  • 9
1
vote
3 answers

Simple sql data audit log tables

I have a requirement to log all changes in a table. I have gone through many articles in SO on data audit logging. All seem to be complex to me. I plan to keep a copy of the table with all before update and deleted data. Is this a good idea?
zak
  • 310
  • 3
  • 19
1
vote
1 answer

Select from audit table

I have following table column1 column2 newvalue oldvalue in columns newvalue oldvalue are values (foreign keys) from other table. I need display some other column from referenced table(i.e. based on primary keys). So in select instead of newvalue…
Maerorek
  • 109
  • 1
  • 3
  • 9
1
vote
2 answers

How to fetch the most recent timestamped record for the same id from MySQL table?

Possible Duplicate: Fetch the row which has the Max value for a column I have an audit table of people and the number of shares they own at a particular timestamp. How do I fetch the most recent record for a given id? mysql audit table id name…
ThinkCode
  • 7,841
  • 21
  • 73
  • 92
1
vote
2 answers

Hibernate canot insert null into audit column on delete

I recently added a new column "PASSWORD_RESET_REQUIRED" into my user and user_audit table. Not when I am trying to delete a user I get an error saying : cannot insert NULL into ("USER_AUD"."PASSWORD_RESET_REQUIRED") @Entity @Table(name =…
user620339
  • 851
  • 3
  • 20
  • 42
0
votes
1 answer

PUT vs POST in an audit-table or revision history situation

Let's say I have a REST method to update a record. That would obviously be a POST because it's updating a resource. However in the same motion, a new record in an audit or revision history table needs to be created. Is there a standard or best…
Scott Hildebrand
  • 53
  • 4
0
votes
3 answers

'Getting only updates' Design

My system needs to get only the updates from the server. How do I design my database? Have an audit table or is there any other design mechanism? What I'm planning is to send an update id from my device, and retrieve the new updates. How to really…
Sivaneasharajah Lushanthan
  • 3
  • 1
0
votes
3 answers

SQL-Server Trigger on update for Audit

I can't find an easy/generic way to register to an audit table the columns changed on some tables. I tried to do it using a Trigger on after update in this way: First of all the Audit Table definition: CREATE TABLE [Audit]( [Id] [int] IDENTITY(1,1)…
Santiago
  • 2,190
  • 10
  • 30
  • 59
0
votes
1 answer

Getting trigger to insert changed column values only in audit table

I'm using a trigger to store changes in an audit table, I only want to store the values from columns that have been changed. BEGIN IF NEW.history_of_repair_trigger_fired = 1 THEN INSERT INTO history_of_repair…
cw84
  • 2,111
  • 5
  • 24
  • 37
0
votes
0 answers

can we make audit table as insensitive, want to use both _AUD and _aud for audited Table

can we make audit table as insensitive, want to use both _AUD and _aud for audited Table. we are creating some tables from local microservice and some tables from other external service jar file. they are using _AUD for audit table and local service…
govind
  • 1
  • 2
  • 4
0
votes
1 answer

Manually update hibernate envers audit table with few properties

I am using hibernate envers in my springboot project. So the audit table will have all historic data except data for deleted revision because in properties file we didn't set spring.jpa.properties.org.hibernate.envers.store_data_at_delete=true Now…
Gopinath
  • 121
  • 1
  • 2
  • 10
0
votes
1 answer

How do I write to an external audit database in SQL Server 2008?

I have a SQL Server 2008 database with 10 windows users who all have permissions to Insert, Update and Delete tables. Each table has a trigger that writes to an audit table in a different database. Currently for this to work I have to give the user…
Andre
  • 1,852
  • 1
  • 16
  • 21
1 2
3
4 5