From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Edwin UY <edwin.uy@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Foreign tables - oracle_fdw
Date: Sun, 05 May 2024 06:02:19 +0200
Message-ID: <07e2f61f5676a2db6fb48247a4ae430d673b422f.camel@cybertec.at> (raw)
In-Reply-To: <CA+wokJ-WsCCdp+jihrC0VCwDroPjSfzy3fy46-N2yTG4p=xMfA@mail.gmail.com>
References: <CA+wokJ-WsCCdp+jihrC0VCwDroPjSfzy3fy46-N2yTG4p=xMfA@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, edwin.uy@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Foreign tables - oracle_fdw
In-Reply-To: <07e2f61f5676a2db6fb48247a4ae430d673b422f.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox