Re: [HACKERS] SESSION_USER - Mailing list pgsql-docs

From Tom Lane
Subject Re: [HACKERS] SESSION_USER
Date
Msg-id 4562.955747814@sss.pgh.pa.us
Whole thread Raw
In response to SESSION_USER  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Re: [HACKERS] SESSION_USER  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-docs
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> create_table.sgml mentions SESSION_USER is not supported.  I don't think
> that is true anymore, is it?

regression=# select session_user;
 getpgusername
---------------
 postgres
(1 row)

Looking at the spec, we do seem to be missing SYSTEM_USER out of the
four variants the spec mentions.  However, considering that we map
them all to the same thing anyway, I can't get too excited about it.

If something is done about making functions have setuid-like behavior,
we'd want to make sure that the appropriate ones of these functions
change value inside a function.

            regards, tom lane

pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: SESSION_USER
Next
From: Bruce Momjian
Date:
Subject: Doc TODO list is done