Questions tagged [auditing]
330 questions
2
votes
1 answer
Hibernate Envers 4.3 migration to 5.0 - conditional envers auditing
My application uses envers to write data to _aud tables and also to wrap it into an xml that is written into another table.
I do it in Envers 4.3 with conditional auditing. My class extends EnversIntegrator
@Override
public void…
4444mad
- 61
- 1
- 9
2
votes
2 answers
SQL Server Azure Data Changes Auditing Techniques
I am new to SQL Azure and I have a task to Implementing Auditing Techniques on SQL Server Azure database.
Can you someone please help me what are the different techniques available for Auditing data changes in SQL Azure. Any reference links will…
2
votes
1 answer
Enabling Auditing on Azure SQL Server (V12) breaks ADO.NET connection
In an attempt to do some basic profiling on our Azure SQL Server (V12) we enabled Auditing using the Azure portal.
Not many seconds later I had an angry developer on my hands that could not connect to the database using his client (HTML5 page).
I…
Anders Rask
- 862
- 6
- 17
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
Security events taxonomy
We are currently implementing a security log monitoring/auditing application for local law compliance.
In our first implementation we used the security event taxonomy proposed by the OpenGroup XDAS working group since the interesting Common Event…
Alessandro Baldoni
- 132
- 7
2
votes
0 answers
Spring data elasticsearch auditing using annotations
I am using spring data elasticserch to persist the documents into elasticsearch. Following is my document structure:
@Id
private String id;
@JsonFormat(shape = JsonFormat.Shape.STRING, pattern = "yyyy-MM-dd'T'HH:mm:ssZ")
@Field(type…
Darshan Mehta
- 30,102
- 11
- 68
- 102
2
votes
1 answer
Audting in Oracle 11g release 2
We have set audit_trail to DB, extended.I m trying to restrict the audit for specific users. But all users(objects) DML operations are auditing by default.
I tried to stop the auditing using all these statements:
SQL> NOAUDIT ALL;
Noaudit…
user3171342
- 51
- 2
- 10
2
votes
1 answer
nhibernate interceptors with domain context
Is it possible (in a clean fashion) to create an audit interceptor in hibernate 2.1 and pass in a domain context to it?
What I would like to achieve is to set a Date Time (can be done easy peasy - found loadsa articles after a quick google), but…
Mark H
- 707
- 1
- 11
- 21
2
votes
2 answers
SQL Server Auditing Alternatives with Application User Tracking
I'm looking for an auditing solution that does exactly what Change Data Capture (CDC) does, except I need it to also track the application user that made the change. I'm currently using SQL Server 2012 Enterprise and may be upgrading to 2014 later…
Wade
- 512
- 3
- 10
2
votes
1 answer
Spring Data JPA programmatically enable auditing
How can I do the same as:
rascio
- 8,968
- 19
- 68
- 108
2
votes
3 answers
Getting the old value and new value between two revisions with Hibernate Envers
This is a follow up question to Retrieve audited entities name, old value and new value of the given revision
I have figured out how to get the two revision of an entity but don't see any easy to find the difference between the two. Is there…
denov
- 11,180
- 2
- 27
- 43
2
votes
1 answer
SQLServer 2008 - Configuring Service Broker between instances
I've been using the scripts from this website to help configure Service Broker based auditing. The first stage - setting up SB between databases on the same instance works fine.
But then, when I try to apply Service Broker between instances, I'm…
JustABitOfCode
- 984
- 1
- 7
- 12
2
votes
0 answers
Auditing procfs
I want to keep track on important system changes on GNU/Linux boxes, like disabling PaX, enabling traffic forwarding, ICMP redirects, changing printk verbosity level and so on. At general all these operations base on changes on /proc/sys/kernel/*…
overfail
- 51
- 3
2
votes
3 answers
SQL Server user name functions
Consider this T-SQL:
CREATE USER my_test_user WITHOUT LOGIN;
SELECT USER_NAME(), USER, SUSER_SNAME(),SYSTEM_USER, suser_name();
EXECUTE AS USER = 'my_test_user' WITH NO REVERT;
SELECT USER_NAME(), USER, SUSER_SNAME(),SYSTEM_USER, suser_name();
I'm…
Clyde
- 8,017
- 11
- 56
- 87
2
votes
1 answer
What is the disadvantage of not auditing OneToMany relations?
I am using Hibernate Envers to log all changes to the database. I noticed that when I added an entity which had a ManyToOne relation with another entity a revision was made on the one Side entity as well. The foreign key is on the many side of the…
Rohit Banga
- 18,458
- 31
- 113
- 191