Re: SV: Foreign tables, user mappings and privilege setup

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Niels Jespersen <NJN(at)dst(dot)dk>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: SV: Foreign tables, user mappings and privilege setup
Date: 2020-09-22 14:15:50
Message-ID: 1177001.1600784150@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Niels Jespersen <NJN(at)dst(dot)dk> writes:
> I can create a user mapping for a group (role). This works, but it is not enough to grant the role to the end user (that has inherit defined). The end user must explicitly use "set role" before accessing the foreign table.

Seems right to me. If the user is a member of two groups, each of which
has a mapping for that server, how could the server choose one?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Fabio Ugo Venchiarutti 2020-09-22 14:17:54 Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem?
Previous Message Josef Machytka 2020-09-22 10:46:20 Problems with PostgreSQL on Google compute engine