CVE-2018-16850: SQL Injection
First published: Mon Nov 05 2018(Updated: )
Postgresql before versions 11.1 and 10.6 are vulnerable to SQL injection in pg_upgrade and pg_dump via CREATE TRIGGER ... REFERENCING. Using a purpose-crafted trigger definition, an attacker can cause arbitrary SQL statements to run, with superuser privileges, during the next pg_upgrade of the database or the next pg_dump dump/restore cycle. The attack requires CREATE privilege on some non-temporary schema or TRIGGER privilege on some table. This is exploitable in the default configuration, where all users have CREATE privilege on schema "public".
Credit: secalert@redhat.com secalert@redhat.com
| Affected Software | Affected Version | How to fix |
|---|---|---|
| redhat/postgresql | <11.1 | 11.1 |
| redhat/postgresql | <10.6 | 10.6 |
| ubuntu/postgresql-10 | <10.6 | 10.6 |
| ubuntu/postgresql-10 | <10.6-0ubuntu0.18.04.1 | 10.6-0ubuntu0.18.04.1 |
| ubuntu/postgresql-10 | <10.6-0ubuntu0.18.10.1 | 10.6-0ubuntu0.18.10.1 |
| debian/postgresql-11 | 11.16-0+deb10u1 11.22-0+deb10u1 | |
| PostgreSQL PostgreSQL | >=10.0<10.6 | |
| PostgreSQL PostgreSQL | >=11.0<11.1 | |
| Redhat Enterprise Linux | =7.0 | |
| Redhat Enterprise Linux | =7.4 | |
| Redhat Enterprise Linux | =7.5 | |
| Redhat Enterprise Linux | =7.6 | |
| Canonical Ubuntu Linux | =18.04 | |
| Canonical Ubuntu Linux | =18.10 |
Never miss a vulnerability like this again
Sign up to SecAlerts for real-time vulnerability data matched to your software, aggregated from hundreds of sources.
Reference Links
- https://bugzilla.redhat.com/show_bug.cgi?id=CVE-2018-16850
- https://www.postgresql.org/about/news/1905/
- https://usn.ubuntu.com/3818-1/
- http://www.securityfocus.com/bid/105923
- http://www.securitytracker.com/id/1042144
- https://security.gentoo.org/glsa/201811-24
- https://access.redhat.com/errata/RHSA-2018:3757
- https://launchpad.net/bugs/cve/CVE-2018-16850
- https://bugzilla.redhat.com/show_bug.cgi/show_bug.cgi?id=1649238
- https://bugzilla.redhat.com/show_bug.cgi/show_bug.cgi?id=1649237
- https://bugzilla.redhat.com/show_bug.cgi/show_bug.cgi?id=1649236
- https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=06292bb949e555f34edde7603237194a7daac942
- https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2da33cbd52aaf5cbc4bc6c4e42e8879ee75a859d
- https://www.postgresql.org/message-id/15440-02d1468e94d63d76@postgresql.org
- https://bugzilla.redhat.com/show_bug.cgi/show_bug.cgi?id=1645937#c0
- https://bugzilla.redhat.com/show_bug.cgi?id=1645937
- https://security-tracker.debian.org/tracker/CVE-2018-16850
- https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2018-16850
- https://ubuntu.com/security/notices/USN-3818-1
- https://nvd.nist.gov/vuln/detail/CVE-2018-16850
- https://ubuntu.com/security/CVE-2018-16850
Frequently Asked Questions
What is the severity of CVE-2018-16850?
The severity of CVE-2018-16850 is critical with a CVSS score of 9.8.
How does CVE-2018-16850 affect PostgreSQL?
CVE-2018-16850 affects PostgreSQL versions before 11.1 and 10.6.
How can an attacker exploit CVE-2018-16850?
An attacker can exploit CVE-2018-16850 by using a purpose-crafted trigger definition to cause arbitrary SQL statements to run with superuser privileges.
Which software packages are affected by CVE-2018-16850?
Software packages affected by CVE-2018-16850 include PostgreSQL versions before 11.1 and 10.6, as well as Redhat Enterprise Linux and Canonical Ubuntu Linux.
Where can I find more information about CVE-2018-16850?
More information about CVE-2018-16850 can be found at the following references: [Bugzilla Redhat](https://bugzilla.redhat.com/show_bug.cgi?id=CVE-2018-16850), [PostgreSQL News](https://www.postgresql.org/about/news/1905/), [Ubuntu Security Notices](https://usn.ubuntu.com/3818-1/)
- agent/author
- agent/type
- agent/last-modified-date
- agent/first-publish-date
- collector/launchpad-cve
- source/Launchpad
- collector/redhat-bugzilla
- source/Red Hat
- alias/CVE-2018-16850
- agent/software-canonical-lookup
- agent/severity
- agent/remedy
- agent/references
- agent/softwarecombine
- collector/usn-cve
- source/Ubuntu
- agent/description
- collector/security-tracker-debian
- source/Debian
- agent/tags
- agent/event
- agent/weakness
- collector/nvd-index
- agent/software-canonical-lookup-request
- collector/nvd-cve
- source/NVD
- package-manager/redhat
- package-manager/ubuntu
- package-manager/debian
- vendor/postgresql
- canonical/postgresql postgresql
- version/postgresql postgresql/10.0
- version/postgresql postgresql/11.0
- vendor/redhat
- canonical/redhat enterprise linux
- version/redhat enterprise linux/7.0
- version/redhat enterprise linux/7.4
- version/redhat enterprise linux/7.5
- version/redhat enterprise linux/7.6
- vendor/canonical
- canonical/canonical ubuntu linux
- version/canonical ubuntu linux/18.04
- version/canonical ubuntu linux/18.10