Questions tagged [audit-tables]
73 questions
0
votes
0 answers
SQL tracking changes
Hi i have a view that contains:
ITEMID ITEMNAME STATUS
1001 BRICKS 1
And the table is updatated to:
ITEMID ITEMNAME STATUS
1001 BRICKS1111 1
and i want that status automaticaly would change to 0 when update/insert is made (it can be made…
user2893780
- 121
- 1
- 2
- 9
0
votes
1 answer
Web Application Auditing
How can I audit a web application specifically database changes, when the application is connecting to the database as a system account?
I would like to use a simple database trigger to write to an audit table but I am unsure of how I would be able…
Adonis L
- 1,679
- 4
- 20
- 23
0
votes
1 answer
Get results from AuditCriterion in new class
I Know that when you do this code:
AuditReader reader = AuditReaderFactory.get(entityManager);
reader.createQuery().forRevisionsOfEntity(Person.class,false,true).getResultList();
it returns a tree element array. I want this 3 elements…
cat
- 3
- 3
0
votes
0 answers
Hibernate Envers: AuditQuery throws ClasscastException
I have a basic entity called Report, which is annotated with @Audited annotation. Changes to the entity are being stored in the database correctly by envers, where I have a number of revisions for the Report entity ID 1.
The following code is being…
Petteri Pertola
- 281
- 2
- 6
- 23
0
votes
1 answer
Do audit table APIs exist for MongoDB that can be used along with another SQL database?
Do audit-table APIs exist for MongoDB used together with some other SQL database, that can be told to automatically mimic a normal SQL table's structure, and trigger inserts into that table's MongoDB table-histories at the end of a commit? If so,…
leeand00
- 25,510
- 39
- 140
- 297
0
votes
2 answers
SQL query to turn audit trail in / out times to list of locations
I have a database that is used to track the location of physical objects, lets call them widgets. It has an audit trail table that tracks when a widget is put in a location, and when it leaves a location (and where it went after that).
So…
PaulHurleyuk
- 8,009
- 15
- 54
- 78
0
votes
1 answer
Java Hibernate Envers UpdateLockingStrategy warning HHH000416 On AuditTable
Hi we have a server running with Hibernate the classes are audited with envers.
Like this :
package db.shared;
import interfaces.GuiEditableTable;
import interfaces.ListableEntity;
import interfaces.ShortDescriptable;
import…
Martin Miller
- 1
- 1
0
votes
1 answer
Record at column level changes in mysql table
My client wants to maintain audit at column level. He wants a table which stores all the audits i.e. at column level. I have decided on a table structure. i.e
id,tablename,tablecolumn,primarkey,oldvalue,newvalue,date
But i was wondering how will i…
Hacker
- 7,798
- 19
- 84
- 154
0
votes
1 answer
JPA Audit/History-Data with existing Database-Triggers
I am adding a JPA application to a complex system of many existing applications (written in MS Access, Delphi, Perl, C#, PHP, etc.). The underlying MS-SQL database uses database triggers to write a copy of any altered database entry in a history…
slartidan
- 20,403
- 15
- 83
- 131
0
votes
1 answer
Select only changes to a value from an audit log table
In MS SQL Server 2008 R2, I have a table Foo, and for every insert and update on Foo, I also insert into FooAuditLog the date, user, the PK FooId and a few of the other columns of Foo, including one numeric value, call it cxp.
I now need to retrieve…
cobaltduck
- 1,598
- 5
- 25
- 51
-1
votes
1 answer
Adding JSON data in audit table
I am creating audit tables for my database using sqlalchemy-postgresql-audit but the issue is that it creates a separate audit_table for every table and I wan't to create a common audit_table for all which contains…
Jack
- 222
- 2
- 12
-1
votes
1 answer
Oracle Database Audit table AUD$ moving to other than system tablespace is supported by Oracle?
AUD$ table holds all the database audit information in Oracle Database. And by default it resides in SYSTEM tablespace.
From research I know that using DBMS_AUDIT_MGMT, it is possible to move the AUD$ table to the other tablespace.
My question is,…
Jeethu
- 169
- 7
-2
votes
1 answer
My oracle local database becomes full and locked
I have been using the truncate audit table to solve the issue.
Is there any other better solution than using truncate and clear Aud$ table every day ?
If I use batch file and set task scheduler for clear the audit table every 12 hours does it works…
Omnya
- 1
- 2