Stack Overflow
Stack Overflow

Questions tagged [auditing]

330 questions
0
votes
1 answer

Envers auditing @Embedded and use targetAuditMode NOT_AUDITED

I'm trying to add envers auditing to a model which has some @Embedded elements. Those elements themselves are not audited. On a regular relation field to achieve this, you would write @Audited(targetAuditMode =…
Stijn V
  • 358
  • 3
  • 13
0
votes
1 answer

Why doesn't the deleted table in a FOR/AFTER DELETE Trigger contain data of the Deleted Record?

Given the following audit table: CREATE TABLE Auditing.[Record Deletion Times] ( ID BIGINT IDENTITY NOT NULL, [Schema] NVARCHAR(128) NOT NULL, [Table] NVARCHAR(256) NOT NULL, [Record ID] INT NOT NULL, [Date-Time] DATETIME2 NOT…
Matt Arnold
  • 668
  • 2
  • 8
  • 21
0
votes
0 answers

ARM template for synapse auditing successfully ran but not reflecting the auditing configurations on the azure portal

I am using ARM templates to enable auditing of the synapse pool, but though the template runs successfully in CI/CD release pipeline, the changes made aren't reflected on the portal. What could be the possible issue? I already have the required…
Kavya Verma
  • 11
  • 1
0
votes
1 answer

How to audit user supplied class files to blacklist packages, classes, and methods

I am working on an application that hosts user defined stored procedures that are provided as Java class files. The procedures need to be deterministic, and I want to black list various packages and methods that are sources of non-determinism. I…
aweisberg
  • 131
  • 3
0
votes
2 answers

how to add new column in pg_class for object creation date dumping

I want to create a column in pg_class for object creation dumping but I am not able to add. I am using below query: ALTER TABLE pg_catalog.pg_class ADD COLUMN relcreated TIMESTAMP; when I run this query I'm getting below error: ERROR: permission…
Sadamh Hussain
  • 1
  • 2
  • 6
0
votes
1 answer

Auditing SQL Server - who is changing what and when? SOX complaince

In my organization, we are doing very limited logging or any sort to capture who is changing what and when. I am seeking help here to understand what should be the best practices to capture any logging whatsoever happening in our SQL Server…
ishan sharma
  • 1
  • 3
0
votes
0 answers

How to audit hibernate entity access

I need to log not only modifications, but every access to Entity. I've looked into EntityListeners and Envers but couldn't find anything usefull.
Mikhail Ivanov
  • 19
  • 2
0
votes
2 answers

Using Auditing Tables for Modified/Created Information

I need to keep track of the CreatedByUserId ModifiedByUserId CreatedDateTime ModifiedDateTime for most of my entities. Pretty standard. Do you think it's better to add these columns to every table...or to just have a CreatedAuditEntryId and…
Jeff
  • 35,755
  • 15
  • 108
  • 220
0
votes
2 answers

Storing Audit Storage

For storing audit entries for auditing purposes, I've been wrestling with how to record what data has changed. I've done two different ways in the past, but I'm creating a new system now and am trying to figure out which to use: Have an AuditEntry…
Jeff
  • 35,755
  • 15
  • 108
  • 220
0
votes
1 answer

Store all the queries executed in Oracle Database

How can i store all queries including select query in user defined table considering auditing is not enabled for select queries and we cannot enable it too.
Khushboo Nagaich
  • 1
0
votes
2 answers

Selectively Audit Logging with the ObjectContext.SaveChanges method in Entity Framework

I need to perform audit logging in my application and I want SaveChanges to log any changes to the database. There are certain instances where I don't want the logging to occur. What would be the most elegant way of telling SaveChanges to not…
JimK
  • 3
  • 1
0
votes
2 answers

SQL Server Database Auditing not working for Sysadmin users

I'm trying to Audit Sysadmin users at Database level; however, none of the SELECTS, INSERTS, UPDATES and DELETES are being audited. I created the Server Audit, followed by the Server Audit specification ADD (DATABASE_OBJECT_ACCESS_GROUP) and then…
ugp
  • 119
  • 11
0
votes
1 answer

Exporting GPOs to HTML from non-domain joined computer via Powershell

Looking to get all GPOs exported to a specific folder When trying to get the GPOs from a DC with powershell like this: Get-GPOReport -All -ReportType HTML -server 192.168.1.88 -Path c:\gpor-reports\GPOAll.html I keep getting: Get-GPOReport :…
Dustin Krauss
  • 43
  • 1
  • 1
  • 3
0
votes
1 answer

Insert trigger issue

I am using a simple trigger ins_process for capturing inserts/updates on a table process. This ins_process inserts data into a table process_audit. process has the following data originally inserted, in that order: id name description --- …
Animesh
  • 4,926
  • 14
  • 68
  • 110
0
votes
0 answers

created_by is always set to null in the database and Version does not work properly

I am trying to implement one entity to see how Auditing works in spring. I have tow issues here: First issue is that "created_by" field is always set to null in the database, although I have created a bean of AuditAware and set it to myself. Second…
Hossein
  • 107
  • 1
  • 10
1 2 3
…
21 22