Re: [Zope-DB] Automatic capture of user ids for auditing

2007-11-06 Thread Charlie Clark
Am 06.11.2007, 20:12 Uhr, schrieb Ken Winter <[EMAIL PROTECTED]>: Hi Ken, an interesting problem although probably not unique! It seems like the components that might be able to pass this info to the database are the ZSQL methods and/or the database adapter (PsycopgDA, in this case). So, ques

[Zope-DB] Automatic capture of user ids for auditing

2007-11-06 Thread Ken Winter
I have a Zope site with a PostgreSQL (8.1) back end. Only authenticated users have access to the site and the database. Each database table has created_by and last_updated_by columns for auditing purposes. The question here is: How to get these audit columns *automatically* updated with the u