From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <bruce@momjian.us>
Cc: greatvovan@gmail.com
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: User mapping security
Date: Thu, 09 Nov 2023 17:03:33 -0500
Message-ID: <1258588.1699567413@sss.pgh.pa.us> (raw)
In-Reply-To: <ZU1SOvgnwbBawgzN@momjian.us>
References: <156324246053.1191.5972769566826595079@wrigleys.postgresql.org>
<ZU1SOvgnwbBawgzN@momjian.us>
Bruce Momjian <bruce@momjian.us> writes:
> On Tue, Jul 16, 2019 at 02:01:00AM +0000, PG Doc comments form wrote:
>> I suppose it should be warned on the pages that foreign credentials with be
>> stored as simple text and will be available for viewing in pg_user_mappings.
> I know this is four years old, but the attached patch documents it. I
> don't think postgresql-fdw needs it since it relies on user mapping and
> discourages passwords in the connection string.
This is far too alarmist. It ignores the privilege restrictions that
are built into the pg_user_mappings view. Random users can't see
umoptions.
regards, tom lane
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-docs@postgresql.org
Cc: tgl@sss.pgh.pa.us, bruce@momjian.us, greatvovan@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: User mapping security
In-Reply-To: <1258588.1699567413@sss.pgh.pa.us>
* 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