[COMMITTERS] pgsql: Match pg_user_mappings limits toinformation_schema.user_mapping - Mailing list pgsql-committers

From Noah Misch
Subject [COMMITTERS] pgsql: Match pg_user_mappings limits toinformation_schema.user_mapping
Date
Msg-id E1d7jcZ-00053b-B4@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Match pg_user_mappings limits to information_schema.user_mapping_options.

Both views replace the umoptions field with NULL when the user does not
meet qualifications to see it.  They used different qualifications, and
pg_user_mappings documented qualifications did not match its implemented
qualifications.  Make its documentation and implementation match those
of user_mapping_options.  One might argue for stronger qualifications,
but these have long, documented tenure.  pg_user_mappings has always
exhibited this problem, so back-patch to 9.2 (all supported versions).

Michael Paquier and Feike Steenbergen.  Reviewed by Jeff Janes.
Reported by Andrew Wheelwright.

Security: CVE-2017-7486

Branch
------
REL9_3_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/b5b124046c0dc636d73c4a802bc731431dfd9dba

Modified Files
--------------
doc/src/sgml/catalogs.sgml                 |  7 ++--
src/backend/catalog/system_views.sql       | 10 +++---
src/test/regress/expected/foreign_data.out | 54 ++++++++++++++++++++++++++++++
src/test/regress/expected/rules.out        |  4 ++-
src/test/regress/sql/foreign_data.sql      | 15 +++++++++
5 files changed, 82 insertions(+), 8 deletions(-)


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: [COMMITTERS] pgsql: Translation updates
Next
From: Tom Lane
Date:
Subject: [COMMITTERS] pgsql: Fix possibly-uninitialized variable.