Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Audit Trail for PostgreSQL
Message
From
06/04/2012 16:51:38
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
 
 
To
06/04/2012 07:31:38
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01536887
Message ID:
01540560
Views:
33
You might try on their IRC chat room irc://freenode/postgresql. I use the firefox plugin chatZilla.

>>Hi,
>>
>>I am considering using a PostgreSQL database as a backend for a system currently using DBFs. Can anyone recommend an Audit Trail that will allow me to track who made what changes to certain tables and when the changes were made? I am anticipating that my application will connect to the database using a single user, then will have its own user table which will contain the username/password hash to verify if the person has access to the system. It's this second user name that I will need to track as part of the audit trail.
>
>I'm just reviving this thread in the hopes that someone can recommend an Audit Trail that will work for PostgreSQL. I think the last discussion went off on a tangent (albeit a helpful one) and I still have no real solution. So, let's assume each user has their own login to the database, is there a tool out there which will generate the appropriate triggers and audit tables for me, or do I need to do it manually for each table I want to audit changes to?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform