UBUNTU-CVE-2024-10978

See a problem?
Please try reporting it to the source first.

Source

https://ubuntu.com/security/CVE-2024-10978

Import Source

https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2024/UBUNTU-CVE-2024-10978.json

JSON Data

https://api.osv.dev/v1/vulns/UBUNTU-CVE-2024-10978

Upstream

CVE-2024-10978

Downstream

USN-7132-1

USN-7358-1

Related

Published

2024-11-14T13:15:00Z

Modified

2025-07-18T16:56:20Z

Severity

4.2 (Medium) CVSS_V3 - CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N CVSS Calculator
4.2 (Medium) CVSS_V3 - CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N CVSS Calculator
Ubuntu - medium

Summary

[none]

Details

Incorrect privilege assignment in PostgreSQL allows a less-privileged application user to view or change different rows from those intended. An attack requires the application to use SET ROLE, SET SESSION AUTHORIZATION, or an equivalent feature. The problem arises when an application query uses parameters from the attacker or conveys query results to the attacker. If that query reacts to current_setting('role') or the current user ID, it may modify or return data as though the session had not used SET ROLE or SET SESSION AUTHORIZATION. The attacker does not control which incorrect user ID applies. Query text from less-privileged sources is not a concern here, because SET ROLE and SET SESSION AUTHORIZATION are not sandboxes for unvetted queries. Versions before PostgreSQL 17.1, 16.5, 15.9, 14.14, 13.17, and 12.21 are affected.

References

Affected packages

Ubuntu:Pro:14.04:LTS / postgresql-9.3

Package

Name: postgresql-9.3
Purl: pkg:deb/ubuntu/postgresql-9.3@9.3.24-0ubuntu0.14.04+esm1?arch=source&distro=esm-infra-legacy/trusty

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0Unknown introduced version / All previous versions are affected

Affected versions

9.*

9.3.1-1

9.3.2-1

9.3.2-1ubuntu1

9.3.2-1ubuntu2

9.3.3-1

9.3.3-1bzr1

9.3.3-1bzr2

9.3.4-1

9.3.5-0ubuntu0.14.04.1

9.3.6-0ubuntu0.14.04

9.3.7-0ubuntu0.14.04

9.3.8-0ubuntu0.4.04

9.3.9-0ubuntu0.14.04

9.3.10-0ubuntu0.14.04

9.3.11-0ubuntu0.14.04

9.3.12-0ubuntu0.14.04

9.3.13-0ubuntu0.14.04

9.3.14-0ubuntu0.14.04

9.3.15-0ubuntu0.14.04

9.3.16-0ubuntu0.14.04

9.3.17-0ubuntu0.14.04

9.3.18-0ubuntu0.14.04.1

9.3.19-0ubuntu0.14.04

9.3.20-0ubuntu0.14.04

9.3.21-0ubuntu0.14.04

9.3.22-0ubuntu0.14.04

9.3.23-0ubuntu0.14.04

9.3.24-0ubuntu0.14.04

9.3.24-0ubuntu0.14.04+esm1

Ubuntu:Pro:16.04:LTS / postgresql-9.5

Package

Name: postgresql-9.5
Purl: pkg:deb/ubuntu/postgresql-9.5@9.5.25-0ubuntu0.16.04.1+esm10?arch=source&distro=esm-infra/xenial

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0Unknown introduced version / All previous versions are affected

Fixed

9.5.25-0ubuntu0.16.04.1+esm10

Affected versions

9.*

9.5.0-1

9.5.0-2

9.5.0-3

9.5.1-1

9.5.2-1

9.5.3-0ubuntu0.16.04

9.5.4-0ubuntu0.16.04

9.5.5-0ubuntu0.16.04

9.5.6-0ubuntu0.16.04

9.5.7-0ubuntu0.16.04

9.5.8-0ubuntu0.16.04.1

9.5.9-0ubuntu0.16.04

9.5.10-0ubuntu0.16.04

9.5.11-0ubuntu0.16.04

9.5.12-0ubuntu0.16.04

9.5.13-0ubuntu0.16.04

9.5.14-0ubuntu0.16.04

9.5.16-0ubuntu0.16.04.1

9.5.17-0ubuntu0.16.04.1

9.5.18-0ubuntu0.16.04.1

9.5.19-0ubuntu0.16.04.1

9.5.21-0ubuntu0.16.04.1

9.5.23-0ubuntu0.16.04.1

9.5.24-0ubuntu0.16.04.1

9.5.25-0ubuntu0.16.04.1

9.5.25-0ubuntu0.16.04.1+esm1

9.5.25-0ubuntu0.16.04.1+esm2

9.5.25-0ubuntu0.16.04.1+esm3

9.5.25-0ubuntu0.16.04.1+esm4

9.5.25-0ubuntu0.16.04.1+esm5

9.5.25-0ubuntu0.16.04.1+esm6

9.5.25-0ubuntu0.16.04.1+esm7

9.5.25-0ubuntu0.16.04.1+esm8

Ecosystem specific

{
    "availability": "Available with Ubuntu Pro (Infra-only): https://ubuntu.com/pro",
    "binaries": [
        {
            "binary_name": "libecpg-compat3",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "libecpg-compat3-dbgsym",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "libecpg-dev",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "libecpg-dev-dbgsym",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "libecpg6",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "libecpg6-dbgsym",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "libpgtypes3",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "libpgtypes3-dbgsym",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "libpq-dev",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "libpq-dev-dbgsym",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "libpq5",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "libpq5-dbgsym",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "postgresql-9.5",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "postgresql-9.5-dbg",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "postgresql-9.5-dbgsym",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "postgresql-client-9.5",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "postgresql-client-9.5-dbgsym",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "postgresql-contrib-9.5",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "postgresql-contrib-9.5-dbgsym",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "postgresql-doc-9.5",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "postgresql-plperl-9.5",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "postgresql-plperl-9.5-dbgsym",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "postgresql-plpython-9.5",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "postgresql-plpython-9.5-dbgsym",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "postgresql-plpython3-9.5",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "postgresql-plpython3-9.5-dbgsym",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "postgresql-pltcl-9.5",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "postgresql-pltcl-9.5-dbgsym",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "postgresql-server-dev-9.5",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        },
        {
            "binary_name": "postgresql-server-dev-9.5-dbgsym",
            "binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
        }
    ]
}

Ubuntu:Pro:18.04:LTS / postgresql-10

Package

Name: postgresql-10
Purl: pkg:deb/ubuntu/postgresql-10@10.23-0ubuntu0.18.04.2+esm3?arch=source&distro=esm-infra/bionic

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0Unknown introduced version / All previous versions are affected

Affected versions

10.*

10.1-1

10.1-2

10.2-1

10.3-1

10.4-0ubuntu0.18.04

10.5-0ubuntu0.18.04

10.6-0ubuntu0.18.04.1

10.7-0ubuntu0.18.04.1

10.8-0ubuntu0.18.04.1

10.9-0ubuntu0.18.04.1

10.10-0ubuntu0.18.04.1

10.12-0ubuntu0.18.04.1

10.14-0ubuntu0.18.04.1

10.15-0ubuntu0.18.04.1

10.16-0ubuntu0.18.04.1

10.17-0ubuntu0.18.04.1

10.18-0ubuntu0.18.04.1

10.19-0ubuntu0.18.04.1

10.20-0ubuntu0.18.04.1

10.21-0ubuntu0.18.04.1

10.22-0ubuntu0.18.04.1

10.23-0ubuntu0.18.04.1

10.23-0ubuntu0.18.04.2

10.23-0ubuntu0.18.04.2+esm1

10.23-0ubuntu0.18.04.2+esm2

10.23-0ubuntu0.18.04.2+esm3

Ubuntu:20.04:LTS / postgresql-12

Package

Name: postgresql-12
Purl: pkg:deb/ubuntu/postgresql-12@12.22-0ubuntu0.20.04.1?arch=source&distro=focal

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0Unknown introduced version / All previous versions are affected

Fixed

12.22-0ubuntu0.20.04.1

Affected versions

12.*

12.0-1

12.1-1

12.1-2build1

12.2-1

12.2-1ubuntu2

12.2-4

12.4-0ubuntu0.20.04.1

12.5-0ubuntu0.20.04.1

12.6-0ubuntu0.20.04.1

12.7-0ubuntu0.20.04.1

12.8-0ubuntu0.20.04.1

12.9-0ubuntu0.20.04.1

12.10-0ubuntu0.20.04.1

12.11-0ubuntu0.20.04.1

12.12-0ubuntu0.20.04.1

12.13-0ubuntu0.20.04.1

12.14-0ubuntu0.20.04.1

12.15-0ubuntu0.20.04.1

12.16-0ubuntu0.20.04.1

12.17-0ubuntu0.20.04.1

12.18-0ubuntu0.20.04.1

12.19-0ubuntu0.20.04.1

12.20-0ubuntu0.20.04.1

Ecosystem specific

{
    "availability": "No subscription required",
    "binaries": [
        {
            "binary_name": "libecpg-compat3",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "libecpg-compat3-dbgsym",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "libecpg-dev",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "libecpg-dev-dbgsym",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "libecpg6",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "libecpg6-dbgsym",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "libpgtypes3",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "libpgtypes3-dbgsym",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "libpq-dev",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "libpq5",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "libpq5-dbgsym",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "postgresql-12",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "postgresql-12-dbgsym",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "postgresql-client-12",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "postgresql-client-12-dbgsym",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "postgresql-doc-12",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "postgresql-plperl-12",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "postgresql-plperl-12-dbgsym",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "postgresql-plpython3-12",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "postgresql-plpython3-12-dbgsym",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "postgresql-pltcl-12",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "postgresql-pltcl-12-dbgsym",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        },
        {
            "binary_name": "postgresql-server-dev-12",
            "binary_version": "12.22-0ubuntu0.20.04.1"
        }
    ]
}

Ubuntu:22.04:LTS / postgresql-14

Package

Name: postgresql-14
Purl: pkg:deb/ubuntu/postgresql-14@14.15-0ubuntu0.22.04.1?arch=source&distro=jammy

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0Unknown introduced version / All previous versions are affected

Fixed

14.15-0ubuntu0.22.04.1

Affected versions

14.*

14.1-1ubuntu1

14.2-1

14.2-1ubuntu1

14.3-0ubuntu0.22.04.1

14.4-0ubuntu0.22.04.1

14.5-0ubuntu0.22.04.1

14.6-0ubuntu0.22.04.1

14.7-0ubuntu0.22.04.1

14.8-0ubuntu0.22.04.1

14.9-0ubuntu0.22.04.1

14.10-0ubuntu0.22.04.1

14.11-0ubuntu0.22.04.1

14.12-0ubuntu0.22.04.1

14.13-0ubuntu0.22.04.1

Ecosystem specific

{
    "availability": "No subscription required",
    "binaries": [
        {
            "binary_name": "libecpg-compat3",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "libecpg-compat3-dbgsym",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "libecpg-dev",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "libecpg-dev-dbgsym",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "libecpg6",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "libecpg6-dbgsym",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "libpgtypes3",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "libpgtypes3-dbgsym",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "libpq-dev",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "libpq5",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "libpq5-dbgsym",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "postgresql-14",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "postgresql-14-dbgsym",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "postgresql-client-14",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "postgresql-client-14-dbgsym",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "postgresql-doc-14",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "postgresql-plperl-14",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "postgresql-plperl-14-dbgsym",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "postgresql-plpython3-14",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "postgresql-plpython3-14-dbgsym",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "postgresql-pltcl-14",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "postgresql-pltcl-14-dbgsym",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        },
        {
            "binary_name": "postgresql-server-dev-14",
            "binary_version": "14.15-0ubuntu0.22.04.1"
        }
    ]
}

Ubuntu:24.04:LTS / postgresql-16

Package

Name: postgresql-16
Purl: pkg:deb/ubuntu/postgresql-16@16.6-0ubuntu0.24.04.1?arch=source&distro=noble

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0Unknown introduced version / All previous versions are affected

Fixed

16.6-0ubuntu0.24.04.1

Affected versions

16.*

16.0-2

16.1-1

16.1-1build1

16.1-1build3

16.2-1

16.2-1ubuntu2

16.2-1ubuntu3

16.2-1ubuntu4

16.3-0ubuntu0.24.04.1

16.4-0ubuntu0.24.04.1

16.4-0ubuntu0.24.04.2

Ecosystem specific

{
    "availability": "No subscription required",
    "binaries": [
        {
            "binary_name": "libecpg-compat3",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "libecpg-compat3-dbgsym",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "libecpg-dev",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "libecpg-dev-dbgsym",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "libecpg6",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "libecpg6-dbgsym",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "libpgtypes3",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "libpgtypes3-dbgsym",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "libpq-dev",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "libpq5",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "libpq5-dbgsym",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "postgresql-16",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "postgresql-16-dbgsym",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "postgresql-client-16",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "postgresql-client-16-dbgsym",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "postgresql-doc-16",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "postgresql-plperl-16",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "postgresql-plperl-16-dbgsym",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "postgresql-plpython3-16",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "postgresql-plpython3-16-dbgsym",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "postgresql-pltcl-16",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "postgresql-pltcl-16-dbgsym",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        },
        {
            "binary_name": "postgresql-server-dev-16",
            "binary_version": "16.6-0ubuntu0.24.04.1"
        }
    ]
}