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 по дате отправления: