]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Match pg_user_mappings limits to information_schema.user_mapping_options.
authorNoah Misch <noah@leadboat.com>
Mon, 8 May 2017 14:24:24 +0000 (07:24 -0700)
committerNoah Misch <noah@leadboat.com>
Mon, 8 May 2017 14:24:27 +0000 (07:24 -0700)
commitb2423f0fa21b38e9a33782dccad028dca903ea3d
treec6fb9a079d9c9a723f29900ed8dc700b457f7930
parented36c1fe172aec866d92d6e5071150a0ec901f8b
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
doc/src/sgml/catalogs.sgml
src/backend/catalog/system_views.sql
src/test/regress/expected/foreign_data.out
src/test/regress/expected/rules.out
src/test/regress/sql/foreign_data.sql