Questions tagged [audit-logging]

Audit-logging is the practice of keeping records of system activity

Audit-logging is the practice of keeping records of system activity. Audit logging does not contain information about the technical operation of a system, like print statements, but rather keeps track of discrete events that occur within a system. Examples are "User X accessed data Y at Time T", etc.

389 questions
1
vote
1 answer

type "hstore" is only a shell

I am trying to setup automatic audit Logging in Postgres Using Triggers and Trigger Functions. For this i want to create the table logged_actions in audit schema. When i run the following query : CREATE TABLE IF NOT EXISTS audit.logged_actions ( …
Mani Ratna
  • 883
  • 1
  • 11
  • 30
1
vote
0 answers

Avoid big data in audit logs with sqlalchemy

I need to store some big binary data in a Postgresql database. I also need to have an audit log for this database. But I do not need, and not want, the binary data in the audit logs. I am accessing the database with python via sqlalchemy. Is there a…
Hans
  • 101
  • 4
1
vote
0 answers

SQLAlchemy operation logging

I would like to log SQLAlchemy INSERT\UPDATE\DELETE operations after they have been committed into the database. Is there a way to this based on SQLAlchemy events? Events, such as after_update, after_insert refer to Python objects, thus are not…
Amirfel
  • 57
  • 1
  • 4
1
vote
1 answer

Ansible ad-hoc command with an included name, comment, or description of the action?

Using ansible with logging enabled is useful for auditing the history of actions taken on a server. I argue it is also important to indicate why a specific changes is made. In playbooks, I can use the name keyword to describe what a change is and…
Quinn Comendant
  • 9,686
  • 2
  • 32
  • 35
1
vote
0 answers

Record request and response from client layer for audit logging in .net core without using middleware

Is there a way of logging the request and response from the client layer(not from controller as we can use middleware to log the same there). I am looking to eliminate developer code for audit log here (//log request ,//log response and and creating…
1
vote
0 answers

How to maintain Audit Logs

I am storing user data in MongoDB and want to maintain activity logs for each user. eg: Who logged in and when? Which user perform certain and when they did Also, Admin can query over these logs to search I have certain approach where people…
1
vote
0 answers

Integrating Audit Logs In Rails Application With Mongodb

In my rails application, I want to store every activity that is performed on the model. I am using Postgresql DB but I want to store my logs in MongoDB so that my current infrastructure should not get impacted. I went through mongoid gem but it does…
Hassan Anwer
  • 347
  • 2
  • 14
1
vote
0 answers

Postgres query audit log w/ metrics

My company has a very specific need to audit queries run against the DB, more specifically DML statements less selects. Ideally we want retrieve the specific metrics Who ran the query When was the query run What was the query Table(s) affected by…
AJY
  • 188
  • 2
  • 12
1
vote
1 answer

Grails 4 Audit Logging w/ Spring Security does not record "Actor"

I'm using Spring Security Rest and the Grails Audit Logging plugin. Audit log records are being created with all the correct information except the actor property is always saved with the defaultActor value. Below is my configuration. Does anyone…
SGT Grumpy Pants
  • 4,118
  • 4
  • 42
  • 64
1
vote
1 answer

Change audit log to JSON format in Percona Mysql

How to modify the system variable audit_log_format to change to JSON format. The variable is read-only and cannot be changed when the server is running. mysql> SHOW variables LIKE 'audit%'; +-----------------------------+---------------+ |…
LvyIN
  • 11
  • 1
1
vote
2 answers

Cloud Firestore's audit logs includes delete collections?

I understand that audit logs includes by default Admin activities like 'delete' but I can't find any logs in the GCP logs registry related to created or deleted collections in my Firestore project. I used the following…
Troglo
  • 1,497
  • 17
  • 18
1
vote
1 answer

Where can I find details of the fields in an Azure AD Audit Log?

We have an application which parses the Audit Logs emitted by Azure AD. More specifically we are parsing the 'Update application' log to detect when a new Role has been added to an Application (see example below). We would like to find out more…
FunkyMJ
  • 13
  • 5
1
vote
1 answer

How do I properly use Oracle Flashback to audit table changes with user information?

My organization has chosen to use Oracle Flashback to replace manually created audit tables. However, the DBA set the TUNED_AUTORETENTION values and UNDO_RETENTION to only 14400 seconds. Unfortunately, we have to keep the audit values for 7 years…
C. Allen
  • 35
  • 4
1
vote
1 answer

Google Data Studio - tracking viewer credentials in GCP audit logging

Does anyone know if its possible to track viewer credentials of users accessing a dashboard on google data studio via GCP audit logging? Currently, I am able to track the viewer email that is accessing via the bigquery.bi.engine resource below. But…
1
vote
0 answers

Decrease Audit.Net time while creating audit entries

Current Scenario We have an endpoint and it has an entity and in that entity it has List of other entity. When we send request to it without Audit.Net configurations the response time can be 710ms to 723ms. But when we add Audit.Net, the response…