Re: Foreign tables - oracle_fdw

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Edwin UY <edwin(dot)uy(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Foreign tables - oracle_fdw
Date: 2024-05-05 04:02:19
Message-ID: 07e2f61f5676a2db6fb48247a4ae430d673b422f.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Edwin UY 2024-05-05 07:29:07 Re: Foreign tables - oracle_fdw
Previous Message Laurenz Albe 2024-05-05 03:58:23 Re: Foreign tables - oracle_fdw