Bug 1182043 – CVE-2014-8161 postgresql: information leak through constraint violation errors

Bugzilla will be upgraded to version 5.0 on a still to be determined date in the near future. The original upgrade date has been delayed.

Bug 1182043 - (CVE-2014-8161) CVE-2014-8161 postgresql: information leak through constraint violation errors

Summary:	CVE-2014-8161 postgresql: information leak through constraint violation errors

Status:	NEW

Aliases:	CVE-2014-8161

Product:	Security Response
Classification:	Other
Component:	vulnerability (Show other bugs)
Sub Component:
Version:	unspecified
Hardware:	All Linux

Priority	medium Severity medium
Target Milestone:	---
Target Release:	---
Assigned To:	Red Hat Product Security
QA Contact:
Docs Contact:

URL:
Whiteboard:	impact=moderate,public=20150205,repor...
Keywords:	Security

Depends On:	1192909 1192910 1198651 1198652 1198653 1198654 1198663 1198672 1198673 1198733
Blocks:	1182046 1188677
	Show dependency tree / graph

Reported:	2015-01-14 05:52 EST by Vasyl Kaigorodov
Modified:	2018-01-30 13:06 EST (History)
CC List:	8 users (show)

See Also:
Fixed In Version:	postgresql 9.0.19, postgresql 9.1.15, postgresql 9.2.10, postgresql 9.3.6, postgresql 9.4.1
Doc Type:	Bug Fix
Doc Text:	An information leak flaw was found in the wathe PostgreSQL database server handled certain error messages. An authenticated database user could possibly obtain the results of a query they did not have privileges to execute by observing the constraint violation error messages produced when the query was executed.
Story Points:	---
Clone Of:
Environment:
Last Closed:
Type:	---
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Attachments	(Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
Red Hat Product Errata	RHSA-2015:0699	normal	SHIPPED_LIVE	Moderate: postgresql92-postgresql security update	2015-03-18 16:35:35 EDT
Red Hat Product Errata	RHSA-2015:0750	normal	SHIPPED_LIVE	Moderate: postgresql security update	2015-03-30 11:30:43 EDT
Red Hat Product Errata	RHSA-2015:0856	normal	SHIPPED_LIVE	Moderate: postgresql92-postgresql security update	2015-04-20 09:46:03 EDT

Groups: None (edit)

Description Vasyl Kaigorodov 2015-01-14 05:52:30 EST

It was reported [1] that a user having the INSERT, UPDATE or DELETE privilege on a table or a subset of its columns but lacking the SELECT privilege on some column may nonetheless be able to acquire values from the denied column.  The user's modification privileges must be sufficient to enable violating some existing constraint.
For example, a user having no SELECT privilege and having the UPDATE privilege on one NOT NULL column can use constraint violation error messages to harvest all values of every other column.

[1]: http://www.postgresql.org/message-id/flat/20140926151728.GN16422@tamriel.snowman.net

Acknowledgements:

Red Hat would like to thank the PostgreSQL project for reporting this issue. Upstream acknowledges Stephen Frost as the original reporter.

Comment 1 Vasyl Kaigorodov 2015-02-04 08:34:05 EST

Upstream patch: https://github.com/postgres/postgres/commit/804b6b6db4dcfc590a468e7be390738f9f7755fb

Comment 2 Huzaifa S. Sidhpurwala 2015-02-16 00:18:50 EST

External References:

http://www.postgresql.org/about/news/1569/

Comment 3 Huzaifa S. Sidhpurwala 2015-02-16 01:53:02 EST

This issue was addressed in Fedora 20 and Fedora 21 via the following security advisories:

https://admin.fedoraproject.org/updates/FEDORA-2015-1728/postgresql-9.3.6-1.fc20
https://admin.fedoraproject.org/updates/FEDORA-2015-1745/postgresql-9.3.6-1.fc21

Comment 15 errata-xmlrpc 2015-03-18 12:36:09 EDT

This issue has been addressed in the following products:

  Red Hat Software Collections 1 for Red Hat Enterprise Linux 7
  Red Hat Software Collections 1 for Red Hat Enterprise Linux 6.6 EUS
  Red Hat Software Collections 1 for Red Hat Enterprise Linux 6
  Red Hat Software Collections 1 for Red Hat Enterprise Linux 6.5 EUS

Via RHSA-2015:0699 https://rhn.redhat.com/errata/RHSA-2015-0699.html

Comment 16 errata-xmlrpc 2015-03-30 07:31:45 EDT

This issue has been addressed in the following products:

  Red Hat Enterprise Linux 7
  Red Hat Enterprise Linux 6

Via RHSA-2015:0750 https://rhn.redhat.com/errata/RHSA-2015-0750.html

Comment 17 errata-xmlrpc 2015-04-20 05:46:27 EDT

This issue has been addressed in the following products:

  Red Hat Satellite Server v 5.7

Via RHSA-2015:0856 https://rhn.redhat.com/errata/RHSA-2015-0856.html

Note You need to log in before you can comment on or make changes to this bug.