postgres_fdw and permissions - Mailing list pgsql-general

From Jeff Janes
Subject postgres_fdw and permissions
Date
Msg-id CAMkU=1yGQRN3i1CU586hsHa7r=JTsCvxTAunJ8-cHcSv8s7SsQ@mail.gmail.com
Whole thread Raw
List 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


pgsql-general by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: SERIALIZABLE and INSERTs with multiple VALUES
Next
From: "Armand Pirvu (home)"
Date:
Subject: functions - triggers cross schemas