Re: current_user versus current_role SOLVED

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: current_user versus current_role SOLVED
Дата
Msg-id BAY20-F177DFE8FB76659ECBFB540F9850@phx.gbl
обсуждение исходный текст
Ответ на Re: current_user versus current_role  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список 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 по дате отправления:

Предыдущее
От: sandeep satpal
Дата:
Сообщение: Query Regarding initdb
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: prefix btree implementation