Niels Jespersen writes:
> I can create a user mapping for a group (role). This works, but it is not
> enough to grant the role to the end user (that has inherit defined). The end
> user must explicitly use "set role" before accessing the foreign table.
Seems right to me. If the user is a membe
>>On Mon, 2020-09-21 at 08:21 +, Niels Jespersen wrote:
>> create user mapping for current_user server s... (user 'remoteuser',
>> password 'remotepassword');
>>
>> create foreign table t ( a int) server s... options (table_name
>> 't_remote');
>>
>> This works fine. Except only the u
