Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kVnfI-0000Bc-Br for pgsql-bugs@arkaria.postgresql.org; Fri, 23 Oct 2020 03:22:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kVnfH-0007lg-53 for pgsql-bugs@arkaria.postgresql.org; Fri, 23 Oct 2020 03:22:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kVnfG-0007j9-VI for pgsql-bugs@lists.postgresql.org; Fri, 23 Oct 2020 03:22:50 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kVnfE-0001DQ-P2 for pgsql-bugs@lists.postgresql.org; Fri, 23 Oct 2020 03:22:50 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.west.internal (Postfix) with ESMTP id 3CEFB53A; Thu, 22 Oct 2020 23:22:47 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Thu, 22 Oct 2020 23:22:47 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=mmHgjLhAyrKBlQseiXPhRi5svop 64G+mqndiddZMQF8=; b=w7zk/zEw71TWFbZH3PLp5knYT8LFun5l5SOdFH/kKAb tdAOI+3MzwavHKSkekchskyiLGF3X3/Dvh+EuZmCmcTuddi+Tq0PGbA8JkIVfvI+ HfvlJleo4UWcvwufmEdiYJBilxlxRCOkZiyj5S20Rvu832vLgTdNPaJotP2g+Sfc VSfLHpPcsSdD8olVnXOryScvTszhWfxu5fNVOY7hxZj40XinggAgwc5We4+Fk7Rq qhXfDm04SbEmLOE+AzzTB3/K9l/IIN+m1MWjK2Hu6+YlW45A1+qKhDR9ICFO9guS AMjsSWcFUQ9TMNjpfr5X0KFeTag7h3Shf5xUYjrnDIQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=mmHgjL hAyrKBlQseiXPhRi5svop64G+mqndiddZMQF8=; b=d4FenZCB/c9tvdOJEz0h+S Gwcf/a3to/pT9vmYIjWkHBjd4uAQjUd08ThSLLeHPqdTCDT7N4TXMm67w2tnC+zT MRlLRUCVpQrfPatLg5Zkg9GreUVM9QVNZTQZbuoj2RtyTROMxIQrn/9EMgML0QI0 QDcShwvjaM/dcFyerqA/WutMI+IlFG/PDlwhX+UQQ3myOt0ktEZPB6Jy20Yk6mK2 ka5kwaq1W78IjwZGxUflIYI9VO4qsmE5BbHJAj9OWfpucNKgoVRb+i6TgmO09M32 49n8CJDWcPw2vJIdxzaMmzKlFego1oAj8zXEg1vVFvMu3maW4E6bl4cMTR8jqWiQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrjeelgdejvdcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdefhedmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttdej necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepueekuedttdelvddvfeejheffleeu ffekteelgfeuffefteeigeehkeegueeflefgnecuffhomhgrihhnpehpohhsthhgrhgvsh hqlhdrohhrghenucfkphepudduuddruddtvddrudektddrudekheenucevlhhushhtvghr ufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquh hivghrrdighiii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id D9206328005A; Thu, 22 Oct 2020 23:22:44 -0400 (EDT) Date: Fri, 23 Oct 2020 12:22:42 +0900 From: Michael Paquier To: Daniel Gustafsson Cc: abcxiaod@126.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16682: The pg_user_mapping table saves the plaintext password Message-ID: <20201023032242.GC5180@paquier.xyz> References: <16682-89078b97ed03d74b@postgresql.org> <78BCA442-5AFB-40E4-B280-69D8EAF234EE@yesql.se> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="YD3LsXFS42OYHhNZ" Content-Disposition: inline In-Reply-To: <78BCA442-5AFB-40E4-B280-69D8EAF234EE@yesql.se> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --YD3LsXFS42OYHhNZ Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Oct 22, 2020 at 10:16:46AM +0200, Daniel Gustafsson wrote: > > On 22 Oct 2020, at 09:14, PG Bug reporting form wrote: >=20 > > Whether the plaintext password in this system table system view has sec= urity > > risks, is it considered a security vulnerability=EF=BC=9F >=20 > This is as intended, and documented on the pg_user_mapping catalog > description and the pg_user_mappings view: >=20 > https://www.postgresql.org/docs/12/catalog-pg-user-mapping.html > https://www.postgresql.org/docs/12/view-pg-user-mappings.html >=20 > The umoptions field is not visible to restricted users. If you care about such things, there are more options on the table like pgpass files or certificate-based authentication methods just to name two of these. Much more options are supported. -- Michael --YD3LsXFS42OYHhNZ Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl+STIIACgkQnvQgOdby QH2erhAAqeo7KWehl6RR2BFSeHTY+/qiysTQ8oRC/fhHPYGhzYQMx5UiSrLhSy11 1Ap8rlsjPCluDBcepVy2cB0BxI2yBrn59627++DInsF61sXrz0SaPSChj5jfGBkr DUzAKYC/YVoLsRaYyCVsPobGkHllOMZsw0Y9VAvU+qZHsTiqoDxwc6gcX65VWGAx TqTanrMx5MihGuIWdvCTT/LlUVhHK8uyNzOBYM7f+Q0wH9SKxwOaJOKEtk9PpclS Jw0maFpD3kXodWhEtKnBqR3WXBW6UxeJOZqWvzKj1DY7LtRT6gmPGo3cu+2dP7Rc 7P21z4lVOQE3GGfAVXKbhdFAamsUr19S/WOYnNti6WMVJENFdDkMaOXChRApZv50 rXug7YKpLSOwcv6OwKXLbfHv8cLNFfwxPXsjKSoy3hKd5+SwbB4wcvmcM74J3qsJ 1hWOgOV7XV0722jN9jktBC3bXXiBBC+jVLAKSIdc1Ebzf97fhvmipq5R3l2tLFMl FM7LD9OrKONQqDePicRT3rZqaaTbTOyG5+Brnk4d3CP85lCR2iHdWQDH5luzgFWy SK2C28IFPS/Fg/4d6++ThrUfRKcjIWD0JXIo++ffE+0S7TsdJ2uXtyYUkxBIeJec /ovnaplrl+96A7B+o4nAh47p0Dpfmu8lUHmeepjS5s/8lSh6NeY= =rP8Y -----END PGP SIGNATURE----- --YD3LsXFS42OYHhNZ--