current_user versus current_role
От | Pavel Stehule |
---|---|
Тема | current_user versus current_role |
Дата | |
Msg-id | BAY20-F86F0D2FCDAFBF082211EFF9820@phx.gbl обсуждение исходный текст |
Ответы |
Re: current_user versus current_role
|
Список | 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 по дате отправления: