Questions tagged [auditing]
330 questions
3
votes
3 answers
Tracking changes on instances of a class and their associations - thoughts?
I have a class Question which has a lot of assocated models. On one page on my app i list a summary of all the current questions, with various info from associated records. Ultimately this is a hash of values that i then just print out into a…

Max Williams
- 32,435
- 31
- 130
- 197
3
votes
1 answer
create envers audit table at different database and preferrably logging done in a different transaction
Hibernate envers creates the audit tables in the same database ,I needed to use other database at a different location to create and maintain these audit tables (preferrable not in the same transaction).
As per my understanding the logging is done…

sHIELD
- 31
- 3
3
votes
1 answer
Audit windows activity of user on WinFormApplication
I need to implement Audit Trail in my application which is WinForm application.
I need to log all the activity done by user on application and in System to see if he had changed any security settings or anything.
Is there any way to do this by AOP…

XYZ
- 119
- 1
- 12
3
votes
1 answer
NHibernate Envers: Auditing entity based on property value
I have a very specific need for auditing.
Consider the following class (I changed the name of my classes and trimmed unnecessary code for the sake of simplicity)
[Audited]
public class Client
{
[NotAudited]
public virtual IList Orders…

Sam
- 13,934
- 26
- 108
- 194
3
votes
2 answers
Auditing in Oracle
I need some help in auditing in Oracle. We have a database with many tables and we want to be able to audit every change made to any table in any field. So the things we want to have in this audit are:
user who modified
time of change…

Alvaro Castro
- 199
- 1
- 4
- 22
3
votes
2 answers
Is there a way to bypass AuditingEntityListener to set up data for a test?
We've got a Spring project that is using the AuditingEntityListener on our JPA entities:
@EntityListeners(AuditingEntityListener.class)
Our base entity has a lastModifiedDate defined as:
@Column(name =…

Chris Williams
- 11,647
- 15
- 60
- 97
3
votes
0 answers
Apache Camel | Tracer vs Event Notifier for generating audit information
Subsequent to my earlier question Apache Camel Tracer | Would log level make a difference in the amout of information logged related to Tracer, I am bit confused whether i should go for a customized tracer or a customized event notifier to generate…

Manchanda. P
- 221
- 1
- 4
- 19
3
votes
1 answer
Auditing an Oracle constraint violation?
Can I audit an Oracle constraint violation?
I created a constraint in a table and I want to audit it when some process violates this constraint. Is this possible? How can I do it?
I'm using Oracle 11g.

Flavio
- 45
- 1
- 1
- 5
3
votes
0 answers
Auditing specific syscall parameter value
I want to deploy auditing focused on some more sophisticated scenarious on my GNU/Linux boxes, for instance execution of commands like touch -m 'faketime' somefile. I straced the exec and found out the difference between normal touch and touch with…

overfail
- 51
- 3
3
votes
1 answer
How can I do generic field and component-level change tracking in NHibernate?
In my application, I've got a few different types of entities that I have a requirement to do field-level change tracking on. I've googled for this and only can come up with examples on doing simple "Date Inserted" and "Date Updated" audit tracking…

David Archer
- 2,121
- 1
- 15
- 26
3
votes
2 answers
Audit Triggers: Use INSERTED or DELETED system tables
The topic of how to audit tables has recently sprung up in our discussions... so I like your opinion on whats the best way to approach this. We have a mix of both the approaches (which is not good) in our database, as each previous DBA did what…

UB.
- 367
- 5
- 14
3
votes
3 answers
Best way of recording activity from a user in the database?
I am building an application that perform checks on users on specific days. I need to keep track of how many times these checks are performed against that particular user.
My initial thought was to just basically have a field in one of my tables…

James
- 80,725
- 18
- 167
- 237
2
votes
1 answer
audit log for any persisted changes, without using database triggers, instead use spring/hibernate
Everytime a user makes an alteration to a record and saves it. I want an audit log for that change. Say for example we have a customer table and the gui shows customer info and sales, I also want to the gui to show an audit log for that customer.…

NimChimpsky
- 46,453
- 60
- 198
- 311
2
votes
1 answer
Retrieve Hardware Informations through SNMP
I am trying to retrieve hardware informations from a series of devices, so far I used snmpget/snmpwalk with the following OID 1.3.6.1.2.1.25.3.2.1 but it returns very few informations, for example if I run this on my computer from a Windows OS I get…

raz3r
- 3,071
- 8
- 44
- 66
2
votes
2 answers
SQLAlchemy: Set audit columns prior to insert or update
Each of my mapped class contains created_by and updated_by audit properties that I would like to set automatically upon INSERT and UPDATE of respective objects.
class User(Base):
__tablename__ = 'user'
id = Column(BigInteger,…

Keerthi
- 466
- 6
- 12