Bug 1508823 (CVE-2017-15099)

Summary:	CVE-2017-15099 postgresql: INSERT ... ON CONFLICT DO UPDATE fails to enforce SELECT privileges
Product:	[Other] Security Response	Reporter:	Adam Mariš <amaris>
Component:	vulnerability	Assignee:	Red Hat Product Security <security-response-team>
Status:	CLOSED WONTFIX	QA Contact:
Severity:	low	Docs Contact:
Priority:	low
Version:	unspecified	CC:	bkearney, databases-maint, devrim, dmoppert, ggainey, hhorak, jmlich83, jorton, jstanek, meissner, mike, pebarbos, pkajaba, pkubat, praiskup, security-response-team, taw, tgl, thomas, tlestach
Target Milestone:	---	Keywords:	Security
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:	postgresql 9.5.10, postgresql 9.6.6, postgresql 10.1	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2017-11-13 10:38:51 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:	1612669, 1612670, 1612671, 1612672
Bug Blocks:	1508824

Description Adam Mariš 2017-11-02 10:03:17 UTC

INSERT ... ON CONFLICT DO UPDATE commands disclose table contents that the
invoker lacks privilege to read. These exploits affect only tables where the
attacker lacks full read access but has both INSERT and UPDATE privileges.
Exploits bypass row level security policies and lack of SELECT privilege.
Even then, not all columns are subject to disclosure.

Vulnerable Versions: 9.5 - 10

Comment 1 Adam Mariš 2017-11-02 10:03:27 UTC

Acknowledgments:

Name: the PostgreSQL project
Upstream: Dean Rasheed

Comment 2 Pedro Yóssis Silva Barbosa 2017-11-13 08:58:31 UTC

Statement:

This issue affects the versions of rh-postgresql95-postgresql, and rh-postgresql96-postgresql as shipped with Red Hat Software Collections 3. Red Hat Product Security has rated this issue as having Low security impact. A future update may address this issue. For additional information, refer to the Issue Severity Classification: https://access.redhat.com/security/updates/classification/.

Comment 3 Pedro Yóssis Silva Barbosa 2017-11-13 10:08:36 UTC

External References:

https://www.postgresql.org/about/news/1801/

Comment 4 Pedro Yóssis Silva Barbosa 2017-11-22 19:51:26 UTC

Upstream commit:

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=87b2ebd

Comment 5 errata-xmlrpc 2018-08-20 10:50:21 UTC

This issue has been addressed in the following products:

  Red Hat Software Collections for Red Hat Enterprise Linux 6
  Red Hat Software Collections for Red Hat Enterprise Linux 6.7 EUS
  Red Hat Software Collections for Red Hat Enterprise Linux 7
  Red Hat Software Collections for Red Hat Enterprise Linux 7.3 EUS
  Red Hat Software Collections for Red Hat Enterprise Linux 7.4 EUS
  Red Hat Software Collections for Red Hat Enterprise Linux 7.5 EUS

Via RHSA-2018:2511 https://access.redhat.com/errata/RHSA-2018:2511

Comment 6 errata-xmlrpc 2018-08-27 08:33:41 UTC

This issue has been addressed in the following products:

  Red Hat Software Collections for Red Hat Enterprise Linux 6
  Red Hat Software Collections for Red Hat Enterprise Linux 6.7 EUS
  Red Hat Software Collections for Red Hat Enterprise Linux 7
  Red Hat Software Collections for Red Hat Enterprise Linux 7.3 EUS
  Red Hat Software Collections for Red Hat Enterprise Linux 7.4 EUS
  Red Hat Software Collections for Red Hat Enterprise Linux 7.5 EUS

Via RHSA-2018:2566 https://access.redhat.com/errata/RHSA-2018:2566