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

From Natalie Wenz
Subject postgres_fdw user mapping and role inheritance
Date
Msg-id 2EBBB4BA-B1C9-4978-8182-F35F8831FD0E@ebureau.com
Whole thread Raw
Responses Re: postgres_fdw user mapping and role inheritance
Re: [E-MASIVO][E-MASIVO]postgres_fdw user mapping and role inheritance
List pgsql-admin
Hi all,

We're looking at using postgres_fdw, and while setting it up for a test using postgres 9.4.4, I noticed that it doesn't
seemto honor role inheritance.  

For example, having created foreign_server:

create role local_group with nologin;
create role individual_user;
grant local_group to individual_user;

create user mapping for local_group
   server foreign_server
   options (user 'foreign_user', password '');

create foreign table foreign_table (id serial, data text)
   server foreign_server
   options (schema_name 'some_schema', table_name 'some_table');

When I tried this, individual_user could not select from foreign_table, even though I expected individual_user to
inheritfrom local_group: 
select * from foreign_table;
ERROR:  user mapping not found for "individual_user"

It did work when I created a user mapping for individual_user (to verify that I had the other parts set up correctly):

create user mapping for individual_user
   server foreign_server
   options (user 'foreign_user', password '');


Am I missing something? Is there a way to tell postgres_fdw to allow individual_user to inherit user mappings from
groupsof which it is a part? Is there a reason that it doesn't allow it, or is it a bug or something that hasn't been
implementedyet? (Will it be fixed or implemented in postgres 9.5?)  

Many thanks,
Natalie

pgsql-admin by date:

Previous
From: Yiqing Jin
Date:
Subject: segfault when creating index on huge table
Next
From: Guillaume Lelarge
Date:
Subject: Re: Automatic restore corruption problem