On Sun, 2024-05-05 at 15:07 +1200, Edwin UY wrote: > I also don't have the password of each user. Can I use set role user1 to user5 > to do the CREATE USER MAPPING and CREATE FOREIGN TABLE. I missed that part. As the documentation says: "The owner of a foreign server can create user mappings for that server for any user." Yours, Laurenz Albe