postgres_fdw and permissions

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: postgres_fdw and permissions
Date: 2016-10-13 21:48:38
Message-ID: CAMkU=1yGQRN3i1CU586hsHa7r=JTsCvxTAunJ8-cHcSv8s7SsQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Say user1 creates a foreign table, and grants select permissions on it to
user2.

When user2 selects from the table, whose USER MAPPING is going to be used,
the table owner (user1) or the executing user (user2)?

Is this part of the FDW infrastructure or SQL/MED spec, and so above the
postgres_fdw implementation, or is it a fdw implementor's choice?

Cheers,

Jeff

Browse pgsql-general by date

  From Date Subject
Next Message Armand Pirvu (home) 2016-10-13 22:18:38 functions - triggers cross schemas
Previous Message Kevin Grittner 2016-10-13 21:46:38 Re: SERIALIZABLE and INSERTs with multiple VALUES