Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Audit Trail for PostgreSQL
Message
De
07/04/2012 21:06:10
 
 
À
06/04/2012 16:07:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01536887
Message ID:
01540608
Vues:
40
>>>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?
>
>Have you tried asking on a PG-specific forum?

I've been searching around the postgresql site (and various blogs), but haven't found an on-line forum yet. If you could recommend one that would be great
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform