Hi,
On 2025-01-21 13:28:43 -0500, Chapman Flack wrote:
> On 01/19/25 12:02, Tom Lane wrote:
> > You can build that yourself, typically by adding a trigger that stores
> > the value of "current_user" into inserted/updated rows. (If you want
> > to also track deletions, a separate audit log table w
Chapman Flack writes:
> I wonder how close one could get to the customer request (better
> forensics without having to build extra columns and triggers at the
> SQL level) with an extension and existing hooks.
An extension would be a great solution if we can make it work.
> I haven't used it, bu
On 01/19/25 12:02, Tom Lane wrote:
> You can build that yourself, typically by adding a trigger that stores
> the value of "current_user" into inserted/updated rows. (If you want
> to also track deletions, a separate audit log table would work
> better.) The event-trigger feature might also be us
gresql.org ;
Mahesh Rao ; Nazia Zaidi ;
Jitesh Tiwari ; Nick Wagner ;
Scott Corbin ; Mack Bell ;
Avinash Dubey
Subject: [External] : Re: New feature request for adding session information to
PostgreSQL transaction log
Sumanth Vishwaraj writes:
> We would like PostgreSQL to store the details of
On Wed, 15 Jan 2025 08:54:06 +
Sumanth Vishwaraj wrote:
> Oracle Audit Vault and Database Firewall (AVDF) audits/monitors
> database activities. This product helps enterprises to manage the
> security posture of Oracle , PostgreSQL and other databases.
>
> Oracle AVDF helps customers in Indi
Sumanth Vishwaraj writes:
> We would like PostgreSQL to store the details of who made the change
> (user/session) information in the transaction log.
You can build that yourself, typically by adding a trigger that stores
the value of "current_user" into inserted/updated rows. (If you want
to al
To: Sumanth Vishwaraj ;
pgsql-hackers@lists.postgresql.org
Cc: Mahesh Rao ; Nazia Zaidi
; Jitesh Tiwari ; Nick
Wagner ; Mack Bell ; Avinash
Dubey
Subject: RE: New feature request for adding session information to PostgreSQL
transaction log
Sumanth,
We generally add whatever contextual in
