Re: Foreign tables, user mappings and privilege setup

On Mon, 2020-09-21 at 08:21 +0000, 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 user who created the user mapping can select from foreign table, even if other users have select privilege on the table. They will get a "user mapping not found
> for...".

You have to create a user mapping for every user that is to access the foreign table.

If several users should have the same credentials, use a group.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com