Questions tagged [auditing]

330 questions
0
votes
0 answers

Automatic CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON fields in SQL SERVER 2008 table (without using triggers)

I'm looking for a way to store the date/time a row was updated, inserted, who inserted/updated it (the db user account) that does not rely on triggers in SQL Server 2008. Is this possible? Any suggestions?
0
votes
1 answer

Java-EE-6 / Glassfish: How to access Entity Manager from Custom Audit Module?

I am using Glassfish 3.1.2.2 and I want to collect and store authentication information to my MySQL database attached to the Glassfish application server. So far I successfully implemented a customized audit module which I put into my ejb-project.…
salocinx
  • 3,715
  • 8
  • 61
  • 110
0
votes
1 answer

can record unc connection?

The Pc I use have an UNC file. I'm in a Network with other people. Every other can open the file by tipping in the adress line \\file. Know I want to write a c# programm in Vs2010 which watch over the file I use Win7 32bit. If any one Open the file…
Sam
  • 77
  • 5
0
votes
1 answer

Auditing JPA entities in webapp : how to obtain logged-in user?

I have a simple auditing requirement for my JPA entities : keep the creation and last modification date and author. The author should be the currently logged-in user. I would like to implement this using @PrePersist and @PreUpdate annotations on a…
Pierre Henry
  • 16,658
  • 22
  • 85
  • 105
0
votes
1 answer

Track time spent in MSCRM

My requirement is I need to be able to track time for each sales person on activities. Also a report that administrators can run to see the amount of time each user spent working on calls/sales/opportunities etc. What should I use to track how…
shilpa
  • 1
  • 3
0
votes
1 answer

OpenJPA auditing capabilities

I have a webservice that will be persisting and deleting data to a Database. I want to track in the database which usernames touched which rows of the database. In each table there are columns for usernames to be stored (update columns if you…
SoftwareSavant
  • 9,467
  • 27
  • 121
  • 195
0
votes
1 answer

Auditing! How to implement a centralized Auditing Service for multiple app's?

We have some CRUD web apps running at a client and we'll need to implement an auditing system to track changes made by users in any of these products. Ex.: User ABC created a new Trade (in trades app) User DEF changed address…
-1
votes
1 answer

Quick javascript to audit for duplicate ids in page DOM

I've found that there are a number of duplicate IDs in the project I'm working on. I don't want to scrape through the entire product all at once, or use on overly heavyweight solution like a full HTML validator - I just want a quick script I can run…
Anomaly
  • 932
  • 1
  • 10
  • 18
-1
votes
1 answer

How to write DB2 DDL & DML audit logs as System Application Logs?

I am using DB2 LUW in a windows machine. I want to get the logs for DDL & DML queries used in the database. The default logs(for example S000001.LOG) contains 'null' and not in a readable format. So I enabled auditing and extracted the archived…
Selva
  • 25
  • 6
-1
votes
1 answer

Should Hibernate Envers library be used to business logic?

Simple case: There is a user who wants to know when he changed his username. Should I use auditing data to do that? Are auditing data for admins only?
Marek Raki
  • 3,056
  • 3
  • 27
  • 50
-1
votes
2 answers

SnapLogic pipeline level auditing

I'm working on a project that requires us to develop various pipelines for database views and web services. But there exists a requirement which asks us to audit and log every detail regarding the pipeline, as which pipeline got executed, which…
-1
votes
1 answer

With Windows 2008 R2 how do I audit when an user is added and removed from a local group?

I want to keep an audit when I remove or add users from local groups. Is it possible to filter out which groups? If not, all local groups is fine.
Chaka
  • 1,709
  • 11
  • 33
  • 58
-3
votes
1 answer

A master trigger

friends, I need your help, I have a problem, I need to create a trigger that stores in a table all the interaction (access, insert, update, etc) that runs with the database; that saves who(user), when and what did (the query that was executed) in…
-4
votes
1 answer

Oracle auditing based on user

In oracle 11g version , AUDIT ALL command does not audit dml statements based on user , Anyone please help me come out of this problem
1 2 3
21
22