Test ID:	1.3.6.1.4.1.25623.1.0.891874
Category:	Debian Local Security Checks
Title:	Debian: Security Advisory (DLA-1874-1)
Summary:	The remote host is missing an update for the Debian 'postgresql-9.4' package(s) announced via the DLA-1874-1 advisory.
Description:	Summary: The remote host is missing an update for the Debian 'postgresql-9.4' package(s) announced via the DLA-1874-1 advisory. Vulnerability Insight: * CVE-2019-10208: `TYPE` in `pg_temp` executes arbitrary SQL during `SECURITY DEFINER` execution Versions Affected: 9.4 - 11 Given a suitable `SECURITY DEFINER` function, an attacker can execute arbitrary SQL under the identity of the function owner. An attack requires `EXECUTE` permission on the function, which must itself contain a function call having inexact argument type match. For example, `length('foo'::varchar)` and `length('foo')` are inexact, while `length('foo'::text)` is exact. As part of exploiting this vulnerability, the attacker uses `CREATE DOMAIN` to create a type in a `pg_temp` schema. The attack pattern and fix are similar to that for CVE-2007-2138. Writing `SECURITY DEFINER` functions continues to require following the considerations noted in the documentation: [link moved to references] The PostgreSQL project thanks Tom Lane for reporting this problem. For Debian 8 Jessie, this problem has been fixed in version 9.4.24-0+deb8u1. We recommend that you upgrade your postgresql-9.4 packages. Further information about Debian LTS security advisories, how to apply these updates to your system and frequently asked questions can be found at: [link moved to references] Affected Software/OS: 'postgresql-9.4' package(s) on Debian 8. Solution: Please install the updated package(s). CVSS Score: 6.5 CVSS Vector: AV:N/AC:L/Au:S/C:P/I:P/A:P
Cross-Ref:	Common Vulnerability Exposure (CVE) ID: CVE-2019-10208 https://www.postgresql.org/about/news/1960/ SuSE Security Announcement: openSUSE-SU-2020:1227 (Google Search) http://lists.opensuse.org/opensuse-security-announce/2020-08/msg00043.html
Copyright	Copyright (C) 2019 Greenbone AG

This is only one of 145615 vulnerability tests in our test suite. Find out more about running a complete security audit. To run a free test of this vulnerability against your system, register below.