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