[GENERAL] PHP Web Auditing and Authorization

2010-11-03 Thread Gabriel Dinis
Dear all, Imagine I have two users "Maria" and "Ana" using a PHP site. There is a common Postgres user "phpuser" for both. I'm creating audit tables to track the actions made by each PHP site user. *I have used the following code:* CREATE OR REPLACE FUNCTION MinUser_audit() RETURNS TRIGGER AS $u

Re: [GENERAL] PHP Web Auditing and Authorization

2010-11-03 Thread Gabriel Dinis
Thanks to all. You are great! On Wed, Nov 3, 2010 at 3:16 PM, Bill Moran wrote: > In response to "Massa, Harald Armin" : > > > Bill, > > > > > > > > > > > We got this same kind of thing working by using PostgreSQL env > variables. > > > First, set custom_variable_classes in your postgresql.con