Re: current_user versus current_role

On Wed, Oct 05, 2005 at 03:17:25PM +0200, Pavel Stehule wrote:

Hi,

> I used info from current_user for log. about some operations (who, when, 
> ..). What I can see, current_user is equal current_role function. I had 
> problem with it, because user (if is member of any group role) can change 
> his identity. example: peter is member of role users. But peter can do set 
> role to users. From this moment I lost possibility of get identity if user, 
> because current_user returns users and not peter. I can check it (if some 
> user changed identity) ~ by exampl. test if role has login privilegia, and 
> if not I can stop any operations.

I believe you can use session_user for this.

-- 
Alvaro Herrera                           Developer, http://www.PostgreSQL.org
"Amanece.                                               (Ignacio Reyes)El Cerro San Cristóbal me mira, cínicamente, con
ojosde virgen"