Postgres Pro
Downloads
Home   >   mailing lists

Re: Foreign tables - oracle_fdw - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Foreign tables - oracle_fdw
Date
Msg-id 07e2f61f5676a2db6fb48247a4ae430d673b422f.camel@cybertec.at
Whole thread Raw
In response to Foreign tables - oracle_fdw  (Edwin UY <edwin.uy@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Foreign tables - oracle_fdw
Next
From: Edwin UY
Date:
Subject: Re: Foreign tables - oracle_fdw