Bug 1319806 – CVE-2016-2193 postgresql: row security policies in prepared statements disregard user ID changes

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 1319806 - (CVE-2016-2193) CVE-2016-2193 postgresql: row security policies in prepared statements disregard user ID changes

Summary:	CVE-2016-2193 postgresql: row security policies in prepared statements disreg...

Status:	CLOSED NOTABUG

Aliases:	CVE-2016-2193

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=20160331,repor...
Keywords:	Security

Depends On:	1322984
Blocks:	1319814
	Show dependency tree / graph

Reported:	2016-03-21 11:01 EDT by Andrej Nemec
Modified:	2016-03-31 16:44 EDT (History)
CC List:	6 users (show)

See Also:
Fixed In Version:	postgresql 9.5.2
Doc Type:	Bug Fix
Doc Text:
Story Points:	---
Clone Of:
Environment:
Last Closed:	2016-03-31 16:44:16 EDT
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.)

Groups: None (edit)

Description Andrej Nemec 2016-03-21 11:01:03 EDT

This vulnerability leads to potentially incorrect policies being applied in cases where role-specific policies are used and a given query is planned under one role and then executed under other roles, which could happen under security definer functions or when a common user and query is planned initially and then re-used across multiple SET ROLEs. Applying an incorrect policy may permit a user to complete otherwise-forbidden reads and modifications. This affects only databases that have used CREATE POLICY to define a row security policy.

Comment 1 Andrej Nemec 2016-03-21 11:01:12 EDT

Acknowledgments:

Name: the PostgreSQL project
Upstream: Ashutosh Bapat

Comment 2 Andrej Nemec 2016-03-31 10:49:17 EDT

External references:

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

Comment 3 Tomas Hoger 2016-03-31 16:27:41 EDT

Upstream commit:

http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=db69e58a0642ef7fa46d62f6c4cf2460c3a1b41b

Comment 5 Tomas Hoger 2016-03-31 16:44:16 EDT

Only PostgreSQL 9.5 was affected, which is not yet part of any Red Hat product.

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