Re: SV: Foreign tables, user mappings and privilege setup - Mailing list pgsql-general

From Tom Lane
Subject Re: SV: Foreign tables, user mappings and privilege setup
Date
Msg-id 1177001.1600784150@sss.pgh.pa.us
Whole thread Raw
In response to SV: Foreign tables, user mappings and privilege setup  (Niels Jespersen <NJN@dst.dk>)
List pgsql-general
Niels Jespersen <NJN@dst.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
(thathas 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



pgsql-general by date:

Previous
From: Josef Machytka
Date:
Subject: Problems with PostgreSQL on Google compute engine
Next
From: Fabio Ugo Venchiarutti
Date:
Subject: Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem?