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…
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…
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…
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…
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