Questions tagged [auditing]
330 questions
0
votes
3 answers
To watch SQL column which has been changed recentely
I need to watch sql columns in table, which has been recently changed with out using last modified date
Could you help me to sql query for latest changes.
original table:
S.No Employee id First Name Last Name Address 1
1 00007 …
Vinodh Muthusamy
- 59
- 2
- 7
0
votes
1 answer
override level of subcategory in log4j configuration
There is some auditing in my application. Every audit event has it's own log4j category with name that is prefixed by same string.
EG:
general auditing category name: com.company.audit
web login category name: com.company.audit.web.login
create…
Juraj
- 1,951
- 2
- 21
- 30
0
votes
1 answer
Get audit table name from hibernate envers?
Is it possible to request the name of an audit table for a entity from Hibernate envers? I don't mean the solution of getting Hibernate table name for entity and appending the auditing postfix.
user3612610
- 233
- 4
- 18
0
votes
0 answers
Is there any way to audit all changes in crud generated by Entity Framework? ASP.NET C#
I have a web api, I generate all models with Entity Framework with a database-first approach.
Then what I do is I create all controllers with actions using Entity Framework
, what I want is to find a way to audit all changes by all crud actions…
Pablito0951
- 19
- 5
0
votes
0 answers
SQL Server 2014 sa account audit trail
I need to implement an auditing for everyone logging in to SQL Server 2014 using the sa account. User should be able to provide user id and reason why he/she is logging as sa, which should be stored in a specific table with a timestamp.
What is the…
0
votes
0 answers
Jpa Auditing dont save data in table auditing
I have to implementes Auditing in my aplication.. i inserting this data correctly
but i want to save all atributter from my Entity ,
Exemple, name, epigrafe, .. and olthers.
I implemented the mothod but dosent work, just dont save the…
Eduardo Krakhecke
- 375
- 2
- 10
- 22
0
votes
1 answer
application_name is not available in audit logs in SQL Server 2017
I am looking for a way to fetch client application name in audit logs in SQL Server. As per the MSDN page, it should be available from SQL Server 2017…
0
votes
1 answer
Executing AOP using meld.js(cujojs) for standalone javascript functions is not working
When I try to implement AOP using meld.js (from cujojs) for standalone javascript functions, it is NOT executing Advice. I have been trying with the below code.
var meld = require("meld")
function afterReturn(returnValue){
…
0
votes
1 answer
Spring Auditing - Data too Long on createdBy
Im implementing the auditing based on [1] but im not getting success with @createdBy and @ModifiedBy
@Entity
@EntityListeners(AuditingEntityListener.class)
@Table(name = "entity")
public class myEntity {
@Id…
KpsLok
- 853
- 9
- 23
0
votes
1 answer
In sqlite, how do I use trigger to write to other files?
according to this trigger example
I can use trigger to write to other files for audting trails. How do I exactly do that?
I have tried this to no avail
CREATE TRIGGER log AFTER INSERT ON my_table
BEGIN
ATTACH DATABASE /location/otherfile AS…
ShamanOfTheFrontier
- 11
- 2
0
votes
1 answer
Noaudit all on schema.table-name not working
We have one system status table A in DB and Application process select and update on that table for 4 times in one seconds so huge audit logs are generating.
So I have tried
NOAUDIT ALL on schema.A;
but still audit logs are generated why?
and how…
pramod
- 123
- 1
- 3
- 9
0
votes
2 answers
Audits/Monitoring you have set up at work
I want to set up some auditing and monitoring jobs on my production servers, but my knowledge of SQL Server is limited, so I wanted to reach out and ask you what are the things that you audit and things that you monitor at your own job. Thanks.
A SQL DBA
- 1
- 1
0
votes
1 answer
How to Ignore fields in a parent class when audditing with Javers
I have an entity which extends from anothers, like that:
public class House extends Building{
public Integer idHouse
}
public class Building extends Structure{
}
public class Structure {
public Integer field1;
}
I need to audit changes in House…
Nuria
- 176
- 2
- 11
0
votes
1 answer
Powershell Auditing effective windows share permissions and outputting to CSV
Powershell noob here. I'm trying to create a script that will take a list of users, a list of network shares, enumerate effective permissions for the user/share and output to CSV for audit purposes.
I've had success using GetPACEffectiveAccess from…
EmpTee
- 1
- 2
0
votes
1 answer
Hibernate Envers composite primary key relatedId request
I using Hibernate Envers for auditing and have an issue with composite primary keys. I have many to many entities with composite primary key based on the relating properties. The construct is like following:
@Entity
@Audited
@Table(indexes = {…
user3612610
- 233
- 4
- 18