USN-6968-1

Source
https://ubuntu.com/security/notices/USN-6968-1
Import Source
https://github.com/canonical/ubuntu-security-notices/blob/main/osv/usn/USN-6968-1.json
JSON Data
https://api.test.osv.dev/v1/vulns/USN-6968-1
Related
Published
2024-08-19T15:04:17.039914Z
Modified
2024-08-19T15:04:17.039914Z
Summary
postgresql-12, postgresql-14, postgresql-16 vulnerability
Details

Noah Misch discovered that PostgreSQL incorrectly handled certain SQL objects. An attacker could possibly use this issue to execute arbitrary SQL functions as the superuser.

References

Affected packages

Ubuntu:20.04:LTS / postgresql-12

Package

Name
postgresql-12
Purl
pkg:deb/ubuntu/postgresql-12?arch=src?distro=focal

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0Unknown introduced version / All previous versions are affected
Fixed
12.20-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

Ecosystem specific

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

Ubuntu:22.04:LTS / postgresql-14

Package

Name
postgresql-14
Purl
pkg:deb/ubuntu/postgresql-14?arch=src?distro=jammy

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0Unknown introduced version / All previous versions are affected
Fixed
14.13-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

Ecosystem specific

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

Ubuntu:24.04:LTS / postgresql-16

Package

Name
postgresql-16
Purl
pkg:deb/ubuntu/postgresql-16?arch=src?distro=noble

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0Unknown introduced version / All previous versions are affected
Fixed
16.4-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

Ecosystem specific

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