current_user versus current_role

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема current_user versus current_role
Дата
Msg-id BAY20-F86F0D2FCDAFBF082211EFF9820@phx.gbl
обсуждение исходный текст
Ответы Re: current_user versus current_role  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-hackers
hello

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.

But Is there some possibility get identity of user without impact of change 
of role? (default role?)

thank you
Pavel Stehule

_________________________________________________________________
Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: Vacuum and Transactions
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: current_user versus current_role