"Clark C. Evans" <cce(at)clarkevans(dot)com> writes:
> Sorry to ressurect this thread. However, I've been playing with the new
> role system and I'd prefer to keep CURRENT_USER as the login user, and
> not making it a synonymn for CURRENT_ROLE. In my application, I love the
> ability to "shed" privleges by "SET ROLE dataentry;". However, I need
> CURRENT_USER to remain as 'clark' for audit trail triggers (recording
> that 'dataentry' changed a particular order is kinda useless).
Aren't you looking for SESSION_USER?
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Alvaro Herrera||Date: 2006-07-28 19:14:33|
|Subject: Re: Hash indexes (was: On-disk bitmap index patch)|
|Previous:||From: Bruce Momjian||Date: 2006-07-28 19:00:33|
|Subject: Re: A couple remarks on TODO|