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
