Re: current_user versus current_role SOLVED - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: current_user versus current_role SOLVED
Date
Msg-id BAY20-F177DFE8FB76659ECBFB540F9850@phx.gbl
Whole thread Raw
In response to Re: current_user versus current_role  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
>
>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.
>
>--
it's exactly it what I want.

Thank You
Pavel Stehule

_________________________________________________________________
Najdete si svou lasku a nove pratele na Match.com. http://www.msn.cz/



pgsql-hackers by date:

Previous
From: sandeep satpal
Date:
Subject: Query Regarding initdb
Next
From: Simon Riggs
Date:
Subject: Re: prefix btree implementation