|
I'm using NHibernate on a project and I need to do data auditing. I found this article on codeproject which discusses the IInterceptor interface.
What is your preferred way of auditing data? Do you use database triggers? Do you use something similar to...
Started by IainMH on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
By encapsulating the auditing mechanics in the persistance layer you retain auditing in a few large....
Of course, how you audit the elements of cascaded database platform.
Of your code every knowing you had auditing going on.
|
|
Did you ever use SQL Server auditing features on a production db?
How did that impact on performances, and are there differences you noticed between different versions of SQL Server.
Also how we need to enable the audit features.
Started by balaweblog on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
C2 Audit mode is what you are looking for, triggers seem like not the way to go for auditingI'm afraid there's no ....
Stackoverflow.com/questions/15917/data-auditing-in-nhibernate-and-sqlserver C2 Audit Mode may auditing.
|
|
Need something quick and free for both domain based and workgroup based auditing of pc's and their hardware. all i want is hdd size, cpu and memory. doesn't have to be pretty just easy to deploy on the network. if an agent is required no big deal. gd
Started by dasko on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
For the second one - i use from time to time psexec that executes ocs agent which reports back all software installed and hardware components to central... .
I'm happy user of glpi for tracking buys/licenses and ocs-inventory for gathering stats about computers .
|
Ask your Facebook Friends
|
Our current enterprise solution is a ASP.NET MVC application driven by the Entity Framework. There are a couple links on how to hook into the change events for auditing. I'm not really interested in this.
I'm interested in enterprise level auditing architecture...
Started by RailRhoad on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
TableName, PrimaryKeyValue, ModifiedColumn, OldValue, NewValue, ChangeUser, Change Date
Now, this works great for audit speed, in our code, we have a common....
We have a single audit table, that basically stores the following information.
|
|
I have an existing J2EE enterprise application to which I need to add auditing, i.e. be able to record CRUD operations on several important domain types (Employee, AdministratorRights, etc.).
The application has a standard n-tier architecture:
Web interface...
Started by Andrew Swan on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
auditing we've gone with database-level audit triggers that track operations within the RDBMS://stackoverflow.com/questions/23770/good-strategy-for-leaving-an-audit-trailchange-history-for-db.
|
|
Question is about providing auditing (who used the application, when) and securing (who can launch the application - no fine grain control or data security) a desktop application developed you.
What would you prefer?
Have an authentication mechanism built...
Started by surajs on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
It has the inherent problem that permissions to any configuration and database files is still determined by the underlying... .
Option 1 could be doable somehow at some level, but would likely be quite a mess .
What would you prefer?
Well, I would prefer option 2.
|
|
Does anyone have any recommendations for auditing changes to pre-defined AD object types? For example changes to security groups or adding / deleting or changing user objects.
Before exploring an in-house development solution is anyone aware of off-the...
Started by Ed Blackburn on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
At the very least, if your auditing settings are right, all of this information should be getting.
Quest makes a ton of Active Directory auditing and reporting.
But I'm just laying it out there.
|
|
I'm looking at changing our Auditing process for our SQL Server 2005 databases and I came across Change Data Capture in SQL Server 2008.
This looks like a good idea, and I'm tempted to try it, but before I do has anyone used it in a commercial environment...
Started by MrEdmundo on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
What the CDC gives you is the ability to log the audit information on how it was done using triggers....
I have implemented audit trail solutions intensive for highly transactional databases.
The CDC should is just a means to an end in my opinion .
|
|
Here's a script to turn on an audit rule:
$path = 'C:\...\*' $ACL = new-object System.Security.AccessControl.FileSecurity $AccessRule = new-object System.Security.AccessControl.FileSystemAuditRule("everyone","ExecuteFile","success") $ACL.SetAuditRule(...
Started by Jordan Weinstein on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
This doesn't address your question, I don't know how, but your script can be cleaned up just a bit:
$path = 'C:\...\*' $ACL = new-object Security.AccessControl.FileSecurity $AccessRule = new-object Security.AccessControl.FileSystemAuditRule ` everyone... .
|
|
Hello. I have a problem with a Database at my work. There is currently auditing in place, but its clunky, requires a lot of maintence, and it falls short in a few regards. So I am replacing it.
I want to do this in as generic of a way as possible and ...
Started by TJMonk15 on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
If don't use SQL 2005 a schema changed occured)
If you are doing... .
If you use SQL 2005, then you want this link .
By "added columns" I guess you are looking to audit DDL.
Of your tables, and have the triggers insert into your audit tables.
|
