Questions tagged [auditing]

330 questions
1
vote
0 answers

Auditing for Security and Events in multiple architecture system

We have an application that uses various technologies and frameworks. It is 3 tier, uses Datasets, Object Mapping, MVC, inline SQL with Parameters, Various .NET There is lots going on some third party and lots custom stuff of five years of…
Zippy
  • 455
  • 1
  • 11
  • 25
1
vote
1 answer

MVC3 NHibernate, SQL audit

I have some misunderstandings about the implementation of an SQL audit module, using as ORM Fluent NHibernate. So here is the situation: We are talking about a Client-Server application build on MVC3 framework. Suppose there we have a method which…
Cristian E.
  • 3,116
  • 7
  • 31
  • 61
1
vote
1 answer

Auditing sp_configure SQL Server 2008 Standard Edition

Is there a way to audit calls to sp_configure in SQL Server 2008 Standard Edition? I would like to know whenever someone calls this system stored procedure to change the configuration of the SQL Server.
mitani
  • 25
  • 5
1
vote
1 answer

Login system using physical postgres users not "logical" users

I'm currently building an application that has to conform with SOX auditing requirements. One of these, is that all inserts, updates and deletes (but delete you can ignore), need to leave a trail that is difficult, if not impossible for a standard…
Trent
  • 2,909
  • 1
  • 31
  • 46
1
vote
3 answers

How to audit all changes in a .net application with SQL Server

I have a .net application that uses EF along with mainly SQL Server 2008 but a couple of customers use 2005. In the database there are a few hundred tables. I need to audit a selection of these tables to record all data inserts/updates/deletes. I…
knappster
  • 401
  • 9
  • 23
1
vote
1 answer

Is it possible to audit the changed values using SQL Server Auditing?

Is it possible to audit the changed values using SQL Server Auditing for stored procedures? Note: I'm not talking about CDC. I've got basic auditing working, writing to the security log. If I run an INSERT statement, I get a 33205 event contain…
ssg31415926
  • 1,037
  • 2
  • 13
  • 21
1
vote
2 answers

nhibernate session with custom data and event listeners

For a WCF project I'm working on, I need to implement some kind of audit log for the entities we're persisting. Basically the audit trail will consist of 4 mandatory fields CreatedDateTime CreatedUserID UpdatedDateTime UpdatedUserID I'm trying to…
Duy
  • 1,332
  • 1
  • 10
  • 19
1
vote
1 answer

Configure SVN/TFS to monitor folder and silently check in file changes (for auditing purposes)?

(also posted at ServerFault, but realised there would be more SVN/TFS users here) Bottom line question: Is it possible to create an SVN/TFS repository with an unattended service running that silently checks in all changes made to files in a target…
Laurence
  • 980
  • 12
  • 31
1
vote
1 answer

Spring data auditing not working in my project

I'm trying to configure spring data auditing. I use Hibernate 4.1.6, hibernate-jpa 2.0, spring-data-jpa 1.1.0, spring 3.1.2 (I've added spring-aspects to the dependecies since I got an error without it). I've based my project configuration on this…
Andrea Polci
  • 1,011
  • 13
  • 27
1
vote
1 answer

TFS 2012: Correllating binaries to builds and source code

I'm starting to dive into TFS 2012 and I have a basic understanding of the tiers and how build servers, controllers and agents work and how different build scripts can have different configurations and projects. However, one of the things I'm…
Reacher Gilt
  • 1,813
  • 12
  • 26
1
vote
1 answer

How to create custom field when using hibernate anvers

I'm starting a new project using spring 3.1, hibernate 4 and there is a requirement to track any activity on the application. activity tracking example who changed what? from what to what? and at which time? i've read an introductory tutorial on…
black sensei
  • 6,528
  • 22
  • 109
  • 188
1
vote
1 answer

SQL - Concatenate all columns from any table

I'm using triggers to audit table changes. Right now I capture the individual column changes in the following: DECLARE @statement VARCHAR(MAX) SELECT @statement = 'Col1: ' + CAST(ISNULL(Col1, '') AS VARCHAR) + ', Col2: ' + CAST(ISNULL(Col2, '') AS…
downatone
  • 1,936
  • 2
  • 23
  • 30
0
votes
2 answers

How to do bulk changes in an audited table?

I've got a system where all changes to business objects have to be audited. So an entity MyEntity has a Number property, and when you change this field, the system leaves the original record alone, and makes another record with the new number…
Joshua Frank
  • 13,120
  • 11
  • 46
  • 95
0
votes
1 answer

linq datacontext GetModifiedMembers in Attach scenario

I am trying to implement Optimistic Locking in an asp.net MVC application, as well as provide audit trailing. The audit framework relies on being able to call DataContext.GetModifiedMembers during SubmitChanges, which makes good sense, i guess. The…
Soraz
  • 6,610
  • 4
  • 31
  • 48
0
votes
1 answer

MySQL/Java Auditing of specific fields

I have few tables in which there could be an update on some of the fields. I would like to keep a history of changes of different fields. Different fields however have different types, however I wouldn't want to create many different columns in my…
Luke
  • 1,872
  • 20
  • 31