Re: postgres_fdw user mapping and role inheritance - Mailing list pgsql-admin

From Tom Lane
Subject Re: postgres_fdw user mapping and role inheritance
Date
Msg-id 7673.1437077526@sss.pgh.pa.us
Whole thread Raw
In response to Re: postgres_fdw user mapping and role inheritance  (Natalie Wenz <nataliewenz@ebureau.com>)
Responses Re: postgres_fdw user mapping and role inheritance  (Natalie Wenz <nataliewenz@ebureau.com>)
List pgsql-admin
Natalie Wenz <nataliewenz@ebureau.com> writes:
> Would it be necessary to disambiguate?

Of course.  If the mapping for group_x says to connect to the remote
server as user foo, while the mapping for group_y says to connect
as user bar, then it matters which one we use.  But there would be no
principled way to choose, if the current userid is a member of both
group_x and group_y.

            regards, tom lane


pgsql-admin by date:

Previous
From: Natalie Wenz
Date:
Subject: Re: postgres_fdw user mapping and role inheritance
Next
From: Yiqing Jin
Date:
Subject: Re: segfault when creating index on huge table