Re: postgres_fdw user mapping and role inheritance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Natalie Wenz <nataliewenz(at)ebureau(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: postgres_fdw user mapping and role inheritance
Date: 2015-07-16 20:12:06
Message-ID: 7673.1437077526@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Natalie Wenz <nataliewenz(at)ebureau(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andy Colson 2015-07-16 20:22:20 Re: could not create shared memory segment: Invalid argument
Previous Message Gilberto Castillo 2015-07-16 19:22:32 Re: [E-MASIVO][E-MASIVO]postgres_fdw user mapping and role inheritance