USN-6656-1

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

Source

https://ubuntu.com/security/notices/USN-6656-1

Import Source

https://github.com/canonical/ubuntu-security-notices/blob/main/osv/usn/USN-6656-1.json

JSON Data

https://api.osv.dev/v1/vulns/USN-6656-1

Related

Published

2024-02-26T13:40:22.774831Z

Modified

2024-02-26T13:40:22.774831Z

Summary

postgresql-12, postgresql-14, postgresql-15 vulnerability

Details

It was discovered that PostgreSQL incorrectly handled dropping privileges when handling REFRESH MATERIALIZED VIEW CONCURRENTLY commands. If a user or automatic system were tricked into running a specially crafted command, a remote attacker could possibly use this issue to execute arbitrary SQL functions.

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.18-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

Ecosystem specific

{
    "availability": "No subscription required",
    "binaries": [
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "libecpg-compat3"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "libecpg-compat3-dbgsym"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "libecpg-dev"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "libecpg-dev-dbgsym"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "libecpg6"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "libecpg6-dbgsym"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "libpgtypes3"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "libpgtypes3-dbgsym"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "libpq-dev"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "libpq5"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "libpq5-dbgsym"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "postgresql-12"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "postgresql-12-dbgsym"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "postgresql-client-12"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "postgresql-client-12-dbgsym"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "postgresql-doc-12"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "postgresql-plperl-12"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "postgresql-plperl-12-dbgsym"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "postgresql-plpython3-12"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "postgresql-plpython3-12-dbgsym"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "postgresql-pltcl-12"
        },
        {
            "binary_version": "12.18-0ubuntu0.20.04.1",
            "binary_name": "postgresql-pltcl-12-dbgsym"
        },
        {
            "binary_version": "12.18-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.11-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

Ecosystem specific

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

Ubuntu:23.10 / postgresql-15

Package

Name: postgresql-15
Purl: pkg:deb/ubuntu/postgresql-15?arch=src?distro=mantic

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0Unknown introduced version / All previous versions are affected

Fixed

15.6-0ubuntu0.23.10.1

Affected versions

15.*

15.2-1

15.2-2

15.3-1

15.4-1ubuntu1

15.5-0ubuntu0.23.10.1

Ecosystem specific

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