FreeBSD : PostgreSQL -- Selectivity estimators bypass row security policies (065890c3-725e-11e9-b0e1-6cc21735f730)

medium Nessus Plugin ID 124788

Language:

Synopsis

The remote FreeBSD host is missing one or more security-related updates.

Description

The PostgreSQL project reports :

PostgreSQL maintains statistics for tables by sampling data available in columns; this data is consulted during the query planning process.
Prior to this release, a user able to execute SQL queries with permissions to read a given column could craft a leaky operator that could read whatever data had been sampled from that column. If this happened to include values from rows that the user is forbidden to see by a row security policy, the user could effectively bypass the policy. This is fixed by only allowing a non-leakproof operator to use this data if there are no relevant row security policies for the table.

Solution

Update the affected packages.

See Also

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

http://www.nessus.org/u?2f6bfa3d

Plugin Details

Severity: Medium

ID: 124788

File Name: freebsd_pkg_065890c3725e11e9b0e16cc21735f730.nasl

Version: 1.3

Type: local

Published: 5/13/2019

Updated: 1/17/2020

Supported Sensors: Nessus

Risk Information

VPR

Risk Factor: Low

Score: 1.4

CVSS v2

Risk Factor: Medium

Base Score: 4

Temporal Score: 3

Vector: CVSS2#AV:N/AC:L/Au:S/C:P/I:N/A:N

CVSS v3

Risk Factor: Medium

Base Score: 4.3

Temporal Score: 3.8

Vector: CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:N/A:N

Temporal Vector: CVSS:3.0/E:U/RL:O/RC:C

Vulnerability Information

CPE: p-cpe:/a:freebsd:freebsd:postgresql10-server, p-cpe:/a:freebsd:freebsd:postgresql11-server, p-cpe:/a:freebsd:freebsd:postgresql95-server, p-cpe:/a:freebsd:freebsd:postgresql96-server, cpe:/o:freebsd:freebsd

Required KB Items: Host/local_checks_enabled, Host/FreeBSD/release, Host/FreeBSD/pkg_info

Exploit Ease: No known exploits are available

Patch Publication Date: 5/9/2019

Vulnerability Publication Date: 5/9/2019

Reference Information

CVE: CVE-2019-10130