An information leak was discovered in postgresql in versions before 13.2, before 12.6 and before 11.11. A user having UPDATE permission but not SELECT permission to a particular column could craft queries which, under some circumstances, might disclose values from that column in error messages. An attacker could use this flaw to obtain information stored in a column they are allowed to write but not read.

For more information about these vulnerabilities, refer to the Postgresql News Page.

Note that Nessus has not tested for this issue but has instead relied only on the application's self-reported version number.

The version of postgresql installed on the remote host is prior to 12.7-1. It is, therefore, affected by multiple vulnerabilities as referenced in the ALAS2POSTGRESQL12-2023-004 advisory.

    A flaw was found in postgresql. While modifying certain SQL array values, missing bounds checks let     authenticated database users write arbitrary bytes to a wide area of server memory. The highest threat     from this vulnerability is to data confidentiality and integrity as well as system availability.
    (CVE-2021-32027)

    A flaw was found in postgresql. Using an INSERT ... ON CONFLICT ... DO UPDATE command on a purpose-crafted     table, an authenticated database user could read arbitrary bytes of server memory. The highest threat from     this vulnerability is to data confidentiality. (CVE-2021-32028)

    A flaw was found in postgresql. Using an UPDATE ... RETURNING command on a purpose-crafted table, an     authenticated database user could read arbitrary bytes of server memory. The highest threat from this     vulnerability is to data confidentiality. (CVE-2021-32029)

    An information leak was discovered in postgresql in versions before 13.2, before 12.6 and before 11.11. A     user having UPDATE permission but not SELECT permission to a particular column could craft queries which,     under some circumstances, might disclose values from that column in error messages. An attacker could use     this flaw to obtain information stored in a column they are allowed to write but not read. (CVE-2021-3393)

Tenable has extracted the preceding description block directly from the tested product security advisory.

Note that Nessus has not tested for these issues but has instead relied only on the application's self-reported version number.

The remote Rocky Linux 8 host has packages installed that are affected by multiple vulnerabilities as referenced in the RLSA-2021:2372 advisory.

  - An information leak was discovered in postgresql in versions before 13.2, before 12.6 and before 11.11. A     user having UPDATE permission but not SELECT permission to a particular column could craft queries which,     under some circumstances, might disclose values from that column in error messages. An attacker could use     this flaw to obtain information stored in a column they are allowed to write but not read. (CVE-2021-3393)

  - A flaw was found in postgresql in versions before 13.3, before 12.7, before 11.12, before 10.17 and before     9.6.22. While modifying certain SQL array values, missing bounds checks let authenticated database users     write arbitrary bytes to a wide area of server memory. The highest threat from this vulnerability is to     data confidentiality and integrity as well as system availability. (CVE-2021-32027)

  - A flaw was found in postgresql. Using an INSERT ... ON CONFLICT ... DO UPDATE command on a purpose-crafted     table, an authenticated database user could read arbitrary bytes of server memory. The highest threat from     this vulnerability is to data confidentiality. (CVE-2021-32028)

  - A flaw was found in postgresql. Using an UPDATE ... RETURNING command on a purpose-crafted table, an     authenticated database user could read arbitrary bytes of server memory. The highest threat from this     vulnerability is to data confidentiality. (CVE-2021-32029)

Note that Nessus has not tested for this issue but has instead relied only on the application's self-reported version number.

The remote host is affected by the vulnerability described in GLSA-202105-32 (PostgreSQL: Multiple vulnerabilities)

    Multiple vulnerabilities have been discovered in PostgreSQL. Please       review the CVE identifiers referenced below for details.
  Impact :

    An authenticated remote attacker, by executing malicious crafted       queries, could possibly disclose sensitive information.
  Workaround :

    There is no known workaround at this time.

The remote CentOS Linux 8 host has packages installed that are affected by multiple vulnerabilities as referenced in the CESA-2021:2372 advisory.

  - postgresql: Buffer overrun from integer overflow in array subscripting calculations (CVE-2021-32027)

  - postgresql: Memory disclosure in INSERT ... ON CONFLICT ... DO UPDATE (CVE-2021-32028)

  - postgresql: Memory disclosure in partitioned-table UPDATE ... RETURNING (CVE-2021-32029)

  - postgresql: Partition constraint violation errors leak values of denied columns (CVE-2021-3393)

Note that Nessus has not tested for this issue but has instead relied only on the application's self-reported version number.

The remote Redhat Enterprise Linux 8 host has packages installed that are affected by multiple vulnerabilities as referenced in the RHSA-2021:2372 advisory.

    PostgreSQL is an advanced object-relational database management system (DBMS).

    The following packages have been upgraded to a later upstream version: postgresql (12.7)

    Security Fix(es):

    * postgresql: Buffer overrun from integer overflow in array subscripting calculations (CVE-2021-32027)

    * postgresql: Memory disclosure in INSERT ... ON CONFLICT ... DO UPDATE (CVE-2021-32028)

    * postgresql: Memory disclosure in partitioned-table UPDATE ... RETURNING (CVE-2021-32029)

    * postgresql: Partition constraint violation errors leak values of denied columns (CVE-2021-3393)

    For more details about the security issue(s), including the impact, a CVSS score, acknowledgments, and     other related information, refer to the CVE page(s) listed in the References section.

Tenable has extracted the preceding description block directly from the Red Hat Enterprise Linux security advisory.

Note that Nessus has not tested for these issues but has instead relied only on the application's self-reported version number.

The remote Redhat Enterprise Linux 7 host has packages installed that are affected by multiple vulnerabilities as referenced in the RHSA-2021:2394 advisory.

    PostgreSQL is an advanced object-relational database management system (DBMS).

    The following packages have been upgraded to a later upstream version: rh-postgresql12-postgresql (12.7).

    Security Fix(es):

    * postgresql: Buffer overrun from integer overflow in array subscripting calculations (CVE-2021-32027)

    * postgresql: Memory disclosure in INSERT ... ON CONFLICT ... DO UPDATE (CVE-2021-32028)

    * postgresql: Memory disclosure in partitioned-table UPDATE ... RETURNING (CVE-2021-32029)

    * postgresql: Partition constraint violation errors leak values of denied columns (CVE-2021-3393)

    For more details about the security issue(s), including the impact, a CVSS score, acknowledgments, and     other related information, refer to the CVE page(s) listed in the References section.

Tenable has extracted the preceding description block directly from the Red Hat Enterprise Linux security advisory.

Note that Nessus has not tested for these issues but has instead relied only on the application's self-reported version number.

The remote Redhat Enterprise Linux 8 host has packages installed that are affected by multiple vulnerabilities as referenced in the RHSA-2021:2389 advisory.

    PostgreSQL is an advanced object-relational database management system (DBMS).

    The following packages have been upgraded to a later upstream version: postgresql (12.7)

    Security Fix(es):

    * postgresql: Buffer overrun from integer overflow in array subscripting calculations (CVE-2021-32027)

    * postgresql: Memory disclosure in INSERT ... ON CONFLICT ... DO UPDATE (CVE-2021-32028)

    * postgresql: Memory disclosure in partitioned-table UPDATE ... RETURNING (CVE-2021-32029)

    * postgresql: Partition constraint violation errors leak values of denied columns (CVE-2021-3393)

    For more details about the security issue(s), including the impact, a CVSS score, acknowledgments, and     other related information, refer to the CVE page(s) listed in the References section.

Tenable has extracted the preceding description block directly from the Red Hat Enterprise Linux security advisory.

Note that Nessus has not tested for these issues but has instead relied only on the application's self-reported version number.

The remote Oracle Linux 8 host has packages installed that are affected by multiple vulnerabilities as referenced in the ELSA-2021-2372 advisory.

    pgaudit     [1.4.0-6]
    - Fix build requires

    [1.4.0-5]
    - Fix build requires

    postgresql     [12.7-1]
    - Update to 12.7       Resolves: #1964510       Fix: CVE-2021-32027,CVE-2021-32028

Tenable has extracted the preceding description block directly from the Oracle Linux security advisory.

Note that Nessus has not tested for these issues but has instead relied only on the application's self-reported version number.

This update for postgresql12 fixes the following issues :

Upgrade to version 12.7 :

CVE-2021-32027: Fixed integer overflows in array subscripting calculations (bsc#1185924).

CVE-2021-32028: Fixed mishandling of junk columns in INSERT ... ON CONFLICT ... UPDATE target lists (bsc#1185925).

CVE-2021-32029: Fixed possibly-incorrect computation of UPDATE ...
RETURNING 'pg_psql_temporary_savepoint' does not exist (bsc#1185926).

CVE-2021-3393: Fixed information leakage in constraint-violation error messages (bsc#1182040).

Don't use %_stop_on_removal, because it was meant to be private and got removed from openSUSE. %_restart_on_update is also private, but still supported and needed for now (bsc#1183168).

Re-enable build of the llvmjit subpackage on SLE, but it will only be delivered on PackageHub for now (bsc#1183118).

Disable icu for PostgreSQL 10 (and older) on TW (bsc#1179945).

Note that Tenable Network Security has extracted the preceding description block directly from the SUSE security advisory. Tenable has attempted to automatically clean and format it as much as possible without introducing additional issues.

The version of PostgreSQL installed on the remote host is 11 prior to 11.11, 12 prior to 12.6, or 13 prior to 13.2. As such, it is potentially affected by multiple vulnerabilities :

  - An information leak was discovered in postgresql in versions before 13.2, before 12.6 and before 11.11.
    A user having UPDATE permission but not SELECT permission to a particular column could craft queries     which, under some circumstances, might disclose values from that column in error messages. An attacker     could use this flaw to obtain information stored in a column they are allowed to write but not read.
    (CVE-2021-3393)

  - A flaw was found in PostgreSQL in versions before 13.2, before 12.6, before 11.11. This flaw allows a     user with SELECT privilege on one column to craft a special query that returns all columns of the table.
    The highest threat from this vulnerability is to confidentiality (CVE-2021-20229)

Note that Nessus has not tested for this issue but has instead relied only on the application's self-reported version number.

This update for postgresql12 fixes the following issues :

Upgrade to version 12.6 :

  - Reindexing might be needed after applying this update.

  - CVE-2021-3393, bsc#1182040: Fix information leakage in     constraint-violation error messages.

This update was imported from the SUSE:SLE-15-SP1:Update update project.

This update for postgresql12 fixes the following issues :

Upgrade to version 12.6 :

Reindexing might be needed after applying this update.

CVE-2021-3393, bsc#1182040: Fix information leakage in constraint-violation error messages.

Note that Tenable Network Security has extracted the preceding description block directly from the SUSE security advisory. Tenable has attempted to automatically clean and format it as much as possible without introducing additional issues.

This update for postgresql13 fixes the following issues :

Upgrade to version 13.2 :

  - Updating stored views and reindexing might be needed     after applying this update.

  - CVE-2021-3393, bsc#1182040: Fix information leakage in     constraint-violation error messages.

  - CVE-2021-20229, bsc#1182039: Fix failure to check     per-column SELECT privileges in some join queries.

Note that Tenable Network Security has extracted the preceding description block directly from the SUSE security advisory. Tenable has attempted to automatically clean and format it as much as possible without introducing additional issues.

This update for postgresql13 fixes the following issues :

Upgrade to version 13.2 :

Updating stored views and reindexing might be needed after applying this update.

CVE-2021-3393, bsc#1182040: Fix information leakage in constraint-violation error messages.

CVE-2021-20229, bsc#1182039: Fix failure to check per-column SELECT privileges in some join queries.

Note that Tenable Network Security has extracted the preceding description block directly from the SUSE security advisory. Tenable has attempted to automatically clean and format it as much as possible without introducing additional issues.

The remote Ubuntu 20.04 LTS host has packages installed that are affected by a vulnerability as referenced in the USN-4735-1 advisory.

    Heikki Linnakangas discovered that PostgreSQL incorrectly leaked values of denied columns when handling     certain errors. A remote attacker could possibly use this issue to obtain sensitive information.

Tenable has extracted the preceding description block directly from the Ubuntu security advisory.

Note that Nessus has not tested for this issue but has instead relied only on the application's self-reported version number.

ID	Name	Product	Family	Severity
184156	Puppet Enterprise < 2019.8.6 PostgreSQL Vulnerabilities	Nessus	Misc.	medium
182032	Amazon Linux 2 : postgresql (ALASPOSTGRESQL12-2023-004)	Nessus	Amazon Linux Local Security Checks	high
157772	Rocky Linux 8 : postgresql:12 (RLSA-2021:2372)	Nessus	Rocky Linux Local Security Checks	high
157026	GLSA-202105-32 : PostgreSQL: Multiple vulnerabilities	Nessus	Gentoo Local Security Checks	medium
150837	CentOS 8 : postgresql:12 (CESA-2021:2372)	Nessus	CentOS Local Security Checks	high
150815	RHEL 8 : postgresql:12 (RHSA-2021:2372)	Nessus	Red Hat Local Security Checks	high
150790	RHEL 7 : rh-postgresql12-postgresql (RHSA-2021:2394)	Nessus	Red Hat Local Security Checks	high
150759	RHEL 8 : postgresql:12 (RHSA-2021:2389)	Nessus	Red Hat Local Security Checks	high
150723	Oracle Linux 8 : postgresql:12 (ELSA-2021-2372)	Nessus	Oracle Linux Local Security Checks	high
150100	SUSE SLES12 Security Update : postgresql12 (SUSE-SU-2021:1783-1)	Nessus	SuSE Local Security Checks	high
148419	PostgreSQL 11.x < 11.11 / 12.x < 12.6 / 13.x < 13.2 Multiple Vulnerabilities	Nessus	Databases	medium
147850	openSUSE Security Update : postgresql12 (openSUSE-2021-423)	Nessus	SuSE Local Security Checks	medium
147050	SUSE SLES15 Security Update : postgresql12 (SUSE-SU-2021:0695-1)	Nessus	SuSE Local Security Checks	medium
146789	SUSE SLED15 / SLES15 Security Update : postgresql12 (SUSE-SU-2021:0544-1)	Nessus	SuSE Local Security Checks	medium
146788	SUSE SLED15 / SLES15 Security Update : postgresql13 (SUSE-SU-2021:0543-1)	Nessus	SuSE Local Security Checks	medium
146785	SUSE SLES12 Security Update : postgresql13 (SUSE-SU-2021:0545-1)	Nessus	SuSE Local Security Checks	medium
146494	Ubuntu 20.04 LTS : PostgreSQL vulnerability (USN-4735-1)	Nessus	Ubuntu Local Security Checks	medium

Detections

Analytics

CVE-2021-3393

medium

Tenable Plugins

medium

high

high

medium

high

high

high

high

high

high

medium

medium

medium

medium

medium

medium

medium