| From: | "Pavel Stehule" <pavel(dot)stehule(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | current_user versus current_role |
| Date: | 2005-10-05 13:17:25 |
| Message-ID: | BAY20-F86F0D2FCDAFBF082211EFF9820@phx.gbl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2005-10-05 13:32:51 | Re: current_user versus current_role |
| Previous Message | Rod Taylor | 2005-10-05 13:11:57 | Re: Vacuum and Transactions |