Questions tagged [auditing]
330 questions
1
vote
2 answers
Is there DDL Auditing in SQL Server 2000
And if not, is there a way to tell when a trigger was disabled/enabled?
FOLLOWUP:
It's a rather interesting diagnostic case. I was only involved from the periphery, and the guy doing the diagnostics isn't a database guy.
Anyways, he had a trigger…
Mark Brady
1
vote
1 answer
Spring Boot: getting query string parameters and request body in AuditApplicationEvent listener
Spring Boot REST app here. I'm trying to configure Spring Boot request auditing to log each and every HTTP request that any resources/controllers receive with the following info:
I need to see in the logs the exact HTTP URL (path) that was…

hotmeatballsoup
- 385
- 6
- 58
- 136
1
vote
1 answer
Enable auditing in ArangoDB using Spring
How can I enable auditing in ArangoDB using Spring in order to use @CreatedDate and @LastModifiedDate annotation?
For example, using MongoDB you must add @EnableMongoAuditing likes
import…

Federico Gatti
- 535
- 1
- 9
- 22
1
vote
1 answer
Oracle SYS.AUD$ Audit Actions
We are running into tablespace issues as a result of a large SYS.AUD$ table. Upon further investigation, we identified that 99% of the items in this table were SELECT actions
SELECT COUNT(*) from SYS.AUD$ where ACTION# = 3;
334698880
SELECT…

batese14
- 21
- 3
1
vote
0 answers
Auditing Parallel .Net Services in DB Table
EDIT: This website contains a wealth of information regarding my question: http://www.enterpriseintegrationpatterns.com/patterns/messaging/index.html
I'm working on a C# based windows service that will have 2-3 instances per VM running on 10-20 VMs.…

Jacob Barnes
- 1,480
- 1
- 12
- 29
1
vote
0 answers
SQL Server Auditing- AD Groups are not audited
I need to configure Database Auditing in SQL Server.
I did configure everything but looks like I am not getting expected result.
What I need to do. Audit DML operations (Insert,Update,Delete) for few SQL Server AD GROUPS as most of the users are…

Goutam
- 21
- 2
1
vote
1 answer
Oracle Audit table using trigger
I need to create a trigger in Oracle 11g for auditing a table. I have a table with 16 columns that need to be audited.
For every new insert into a table, I need to put an entry in audit table for each column inserted i.e. in this scenario 16 row…

Ganesh
- 486
- 3
- 8
- 18
1
vote
1 answer
Audit & Telemetry in MS DYNAMICS CRM
Is there any possible way to get advanced auditing options in crm dynamics (third party tool, querying database filteredviews)
I want to know Number of user connected, duration of connection for each user, time passed in each form, reports…

fnando
- 43
- 1
- 8
1
vote
0 answers
Hibernate Envers: Rollback transaction when failed to create a revision
In our project we use envers to keep historical data for our entities. The historical data has a business value. As we know, the auditing occurs at the before completion phase, where exceptions are caught and not propagated.
The scenario is the…

Newton Faria Jr.
- 11
- 2
1
vote
1 answer
Spring-boot with eclipseLink transaction issue
I have implemented EntityListener in eclipseLink. My app is built using spring-boot , spring-data and eclipseLink. I have a requirement of inserting record in 2 table (Audit tables) when data in inserted in 1 table. I have got EntityManager in my…

rishi
- 1,792
- 5
- 31
- 63
1
vote
1 answer
Handling schema change in javers auditing
I have my java class which consists of Map. I am using javers sql repository for storing my auditing data. I recently changed schema of my property to Map>. Now I am getting following exception on commits of the…

anshul jain
- 36
- 6
1
vote
0 answers
merge report:ORA-28138:An invalid policy predicate was specified
When i excute a merge statement:
merge into employees e using new_employees n
on (e.employee_id = n.employee_id)
when matched then
update set e.salary = n.salary
when not matched then
insert…

gaofeng
- 393
- 1
- 3
- 11
1
vote
1 answer
how can i audit specific users' statements on specific tables in oracle
I want to do something like this:
AUDIT SELECT, INSERT, UPDATE, DELETE ON HR.EMP BY SCOTT BY ACCESS;
But it has wrong syntax. To fix it, i have to remove "BY SCOTT". How can i implement auditing similar like this in oracle?
In other words, Scott's…

Отгонтөгс Миймаа
- 753
- 11
- 23
1
vote
1 answer
Spring Data JPA auditing fails when persisting detached entity
I've setup JPA auditing with Spring Data JPA AuditingEntityListener and AuditorAware bean. What I want is to be able to persist auditor details even on entities with predefined identifiers.
The problem is that when JPA entity with predefined id is…

J R
- 223
- 3
- 12
1
vote
3 answers
How to log user operations for a asp.net application?
How can we log user operations for a asp.net application. Further what is the approach for saving the log data ? Kindly guide.

HotTester
- 5,620
- 15
- 63
- 97