Stack Overflow
Stack Overflow

Questions tagged [audit-tables]

73 questions
0
votes
1 answer

Audit-table-DEPT Trigger

What would happen when this database trigger is fired? Command (as user SYS): SQL> CREATE OR REPLACE TRIGGER audit-table-DEPT AFTER INSERT OR UPDATE OR DELETE ON DEPT FOR EACH ROW declare audit_data DEPT$audit%ROWTYPE; begin if inserting then…
Tharindu Chathuranga
  • 25
  • 4
0
votes
1 answer

Old value in _aud table in envers

I have integrated hibernate envers in spring boot. Now my requirement is to have old value also for the particular column when value changed in *_AUD tables. However I cant see any feature available in Hibernate Envers plugin. Please suggest. Thanks
Nikhil Jain
  • 1
  • 1
0
votes
1 answer

How to get old value and new value of multiple field in trigger in SQL server?

I have a table Person: CREATE TABLE Person ( ID INT PRIMARY KEY, FirstName varchar(50), LastName varchar(50), Phone varchar(50), Address varchar(50), City varchar(50), PinCode varchar(50), DateOfBirth DATETIME, …
Tejas
  • 107
  • 4
  • 13
0
votes
0 answers

MySQL trigger after update to insert in audit table

I have a table called tags and tags_audit. I have created a trigger such that if there is an update on one of the fields, I would insert rows equal to the number of fields updated in the row of tags table, into the tags_audit table. Table:…
syedalisait
  • 45
  • 7
0
votes
2 answers

Is there a way to reference an audit table for Specifications (Spring)?

I've been looking for a similar question to this, without success. My goal: I need to obtain the username of whoever created a certain entity, which is stored in the audit table of said entity referenced via Spring's @AuditTable. A bit (hopefully)…
Aron Kim
  • 3
  • 4
0
votes
2 answers

Moving auditing table with java envers to new database instance

I have a Mysql DB, schema name "myschema". This schema has tables, where some of this tables are audit tables. This is my dependency on my java project. org.hibernate hibernate-envers …
freecks
  • 137
  • 4
  • 18
0
votes
1 answer

SSIS loading .csv flat files using For Each Loop Container : Execute SQL Task expression to populate the audit table with Row Count

I am loading many .csv files into a SQL Server table using SSIS (Visual Studio 2017). I am using For Each Loop Container. I have two user variables - FileName (string) and RowCnt (int) I have developed an audit table (dbo.FEfiles) to track each…
user3812887
  • 439
  • 12
  • 33
0
votes
3 answers

TransactionScope + Audit Table + Commit Transaction In Stored Procedure

My company is using SQL Server 2008. I am facing a Audit Table with transaction problems. I have a stored procedure. create proc MySP as begin insert into MY_TABLE values('Value1'); begin transaction TX_MY_SP -- write to audit table…
Alex Yeung
  • 2,495
  • 7
  • 31
  • 48
0
votes
0 answers

Fire Trigger if deleted.Column <> inserted.Column

This is similar to Compare deleted and inserted table in SQL Server 2008 but the results were not what I was looking for. I do want the trigger to fire if a specific column changes, however the program we have does a delete of all information and…
humbeard
  • 23
  • 3
0
votes
1 answer

Hibernate Enver : @AuditJoinTable rows missing

Given an Entity that is audited by Envers, which contains one collection. Entity A @Audited public class A{ @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private int id; .... @OneToMany @JoinColumn(name =…
Himanshu Arora
  • 688
  • 1
  • 9
  • 20
0
votes
0 answers

Declaration of bedezign\yii2\audit\components\panels\DataStoragePanelTrait::getUrl() using yii2-audit

I am using yii2-audit extension for audit logs, I followed all steps of installation and also migrate all tables. But when I update table value then it will return error like Audit module cannot be loaded. I have place behaviors() in my model. My…
Mayank Vadiya
  • 1,437
  • 2
  • 19
  • 32
0
votes
1 answer

Hibernate @Audited fails when saving dates

I have one entity that contains two dates, fromDate, and toDate, and if I dont audit it, it works perfectly, but, if I add the @Audited annotation, I get the following error: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime…
Manuelarte
  • 1,658
  • 2
  • 28
  • 47
0
votes
0 answers

oracle triggers - how to use count

fairly new to triggers so just trying to get my head round on how to create certain triggers. i have to make a doctors practise with patients and the trigger has to count if a patient has made 4 or more appointments their details will be stored into…
joshwaa
  • 21
0
votes
1 answer

Audit Table DB Design : Does creating Audit Tables for Join Tables make sense

we are creating separate audit tables for those entity tables which need auditing using triggers on PostgreSQL 8.4.
We have some join tables. Eg : Family_Contact is a join table. Family has 1 or more…
anjanb
  • 12,999
  • 18
  • 77
  • 106
0
votes
0 answers

Grails + MySQL Strategy for creating audit tables

Our grails app creates the normal tables for storing the domain objects. For fraud and regulatory purposes, the key tables must be audited, i.e. every change should recorded along with who did it, and when. On previous projects, we created a new…
John Little
  • 10,707
  • 19
  • 86
  • 158
1 2 3
4
5