Re: [GENERAL] User action accounting

2010-03-31 Thread Guillaume Lelarge
Le 31/03/2010 07:11, Craig Ringer a écrit : > Joshua Berry wrote: >> Hello All, >> >> I have a few PHP/Clarion based applications that don't currently track >> who created and modified records. I'd like to be able to track all user >> and timestamp pairs for INSERT/UPDATEs by way of triggers. >> >>

Re: [GENERAL] User action accounting

2010-03-30 Thread Craig Ringer
Joshua Berry wrote: > Hello All, > > I have a few PHP/Clarion based applications that don't currently track > who created and modified records. I'd like to be able to track all user > and timestamp pairs for INSERT/UPDATEs by way of triggers. > > The problem is that I currently use the same role

Re: [GENERAL] User action accounting

2010-03-30 Thread Steve Atkins
On Mar 30, 2010, at 8:03 AM, Joshua Berry wrote: > Hello All, > > I have a few PHP/Clarion based applications that don't currently track who > created and modified records. I'd like to be able to track all user and > timestamp pairs for INSERT/UPDATEs by way of triggers. > > The problem is th

Re: [GENERAL] User action accounting

2010-03-30 Thread Andy Colson
On 3/30/2010 11:13 AM, Joshua Berry wrote: On Tue, Mar 30, 2010 at 10:46 AM, Andy Colson mailto:a...@squeakycode.net>> wrote: When your app/users connect to the db, do they connect as the same user, or each with a different username? The application instances each connect to the datab

Re: [GENERAL] User action accounting

2010-03-30 Thread Joshua Berry
On Tue, Mar 30, 2010 at 10:46 AM, Andy Colson wrote: > When your app/users connect to the db, do they connect as the same user, or > each with a different username? > The application instances each connect to the database with the same username. The application currently uses an ODBC connection

Re: [GENERAL] User action accounting

2010-03-30 Thread Andy Colson
On 3/30/2010 10:03 AM, Joshua Berry wrote: Hello All, I have a few PHP/Clarion based applications that don't currently track who created and modified records. I'd like to be able to track all user and timestamp pairs for INSERT/UPDATEs by way of triggers. The problem is that I currently use the