Thread: postgres_fdw and permissions

postgres_fdw and permissions

From
Jeff Janes
Date:

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