Re: BUG #16682: The pg_user_mapping table saves the plaintext password - Mailing list pgsql-bugs

> On 22 Oct 2020, at 09:14, PG Bug reporting form <noreply@postgresql.org> wrote:

> Whether the plaintext password in this system table system view has security
> risks, is it considered a security vulnerability？

This is as intended, and documented on the pg_user_mapping catalog
description and the pg_user_mappings view:

  https://www.postgresql.org/docs/12/catalog-pg-user-mapping.html
  https://www.postgresql.org/docs/12/view-pg-user-mappings.html

The umoptions field is not visible to restricted users.

cheers ./daniel