Re: [v9.2] Add GUC sepgsql.client_label

Yeb Havinga <yebhavinga@gmail.com>

From: Yeb Havinga <yebhavinga@gmail.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Kohei KaiGai <kaigai@kaigai.gr.jp>, PgHacker <pgsql-hackers@postgresql.org>, Joshua Brindle <jbrindle@tresys.com>
Date: 2012-01-31T15:27:08Z
Lists: pgsql-hackers
On 2012-01-31 15:28, Robert Haas wrote:
>
> *scratches head*
>
> I'm not sure I follow you.  If you're saying that we can make this
> work by always allowing the value to be reset, then I agree with you,
> but I'm not sure those are the semantics KaiGai wants.  For instance,
> if a connection pooler does:
>
> SET sepgsql.client_label = 'bob_t';
>
> ...and then hands off to the client, the client can then do:
>
> RESET sepgsql.client_label;
> SET sepgsql.client_label = 'alice_t';
>
> ....and that's bad.

Hmm yes this is a problem. Reading the original post better, it is also 
not the intended behaviour to support repeatable client_label switches.

"However, single-directed domain transition from bigger-privileges to 
smaller-privileged domain by users' operation is also supported on 
operating system, and useful feature to restrict applications capability 
at beginning of the session."

-- 
Yeb Havinga
http://www.mgrid.net/
Mastering Medical Data