postgresql: INSERT ... ON CONFLICT DO UPDATE fails to enforce SELECT privileges
Published Nov 22, 2017
6.5
MEDIUMCVSS 3.0
EPSS 6.32%
Description
INSERT ... ON CONFLICT DO UPDATE commands in PostgreSQL 10.x before 10.1, 9.6.x before 9.6.6, and 9.5.x before 9.5.10 disclose table contents that the invoker lacks privilege to read. These exploits affect only tables where the attacker lacks full read access but has both INSERT and UPDATE privileges. Exploits bypass row level security policies and lack of SELECT privilege.
Affected products
-
- Version 10.x before 10.1, 9.6.x before 9.6.6, 9.5.x before 9.5.10StatusaffectedConstraints-
- Version
Default status is the baseline for the product, each version can override it (e.g. patched versions marked unaffected).
| Vendor | Product | Default status | Versions | ||||||
|---|---|---|---|---|---|---|---|---|---|
| Red Hat, Inc. | PostgreSQL | n/a |
|
Configuration 1
- 9.5
- 9.5.1
- 9.5.2
- 9.5.3
- 9.5.4
- 9.5.5
- 9.5.6
- 9.5.7
- 9.5.8
- 9.5.9
- 9.6
- 9.6.1
- 9.6.2
- 9.6.3
- 9.6.4
- 9.6.5
- 10.0
Configuration 2
- 9.0
No data.
Red Hat Software Collections for Red Hat Enterprise Linux 6
rh-postgresql95-postgresql-0:9.5.14-1.el6
Fixed · RHSA-2018:2511
Red Hat Software Collections for Red Hat Enterprise Linux 6
rh-postgresql96-postgresql-0:9.6.10-1.el6
Fixed · RHSA-2018:2566
Red Hat Software Collections for Red Hat Enterprise Linux 6.7 EUS
rh-postgresql95-postgresql-0:9.5.14-1.el6
Fixed · RHSA-2018:2511
Red Hat Software Collections for Red Hat Enterprise Linux 6.7 EUS
rh-postgresql96-postgresql-0:9.6.10-1.el6
Fixed · RHSA-2018:2566
Red Hat Software Collections for Red Hat Enterprise Linux 7
rh-postgresql95-postgresql-0:9.5.14-1.el7
Fixed · RHSA-2018:2511
Red Hat Software Collections for Red Hat Enterprise Linux 7
rh-postgresql96-postgresql-0:9.6.10-1.el7
Fixed · RHSA-2018:2566
Red Hat Software Collections for Red Hat Enterprise Linux 7.3 EUS
rh-postgresql95-postgresql-0:9.5.14-1.el7
Fixed · RHSA-2018:2511
Red Hat Software Collections for Red Hat Enterprise Linux 7.3 EUS
rh-postgresql96-postgresql-0:9.6.10-1.el7
Fixed · RHSA-2018:2566
Red Hat Software Collections for Red Hat Enterprise Linux 7.4 EUS
rh-postgresql95-postgresql-0:9.5.14-1.el7
Fixed · RHSA-2018:2511
Red Hat Software Collections for Red Hat Enterprise Linux 7.4 EUS
rh-postgresql96-postgresql-0:9.6.10-1.el7
Fixed · RHSA-2018:2566
Red Hat Software Collections for Red Hat Enterprise Linux 7.5 EUS
rh-postgresql95-postgresql-0:9.5.14-1.el7
Fixed · RHSA-2018:2511
Red Hat Software Collections for Red Hat Enterprise Linux 7.5 EUS
rh-postgresql96-postgresql-0:9.6.10-1.el7
Fixed · RHSA-2018:2566
Red Hat Enterprise Linux 5
postgresql
Not affected
Red Hat Enterprise Linux 5
postgresql84
Not affected
Red Hat Enterprise Linux 6
postgresql
Not affected
Red Hat Enterprise Linux 7
postgresql
Not affected
Red Hat Satellite 5
postgresql92-postgresql
Not affected
Red Hat Software Collections
rh-postgresql94-postgresql
Not affected
| Product | Package | State | Advisory |
|---|---|---|---|
| Red Hat Software Collections for Red Hat Enterprise Linux 6 | rh-postgresql95-postgresql-0:9.5.14-1.el6 | Fixed | RHSA-2018:2511 |
| Red Hat Software Collections for Red Hat Enterprise Linux 6 | rh-postgresql96-postgresql-0:9.6.10-1.el6 | Fixed | RHSA-2018:2566 |
| Red Hat Software Collections for Red Hat Enterprise Linux 6.7 EUS | rh-postgresql95-postgresql-0:9.5.14-1.el6 | Fixed | RHSA-2018:2511 |
| Red Hat Software Collections for Red Hat Enterprise Linux 6.7 EUS | rh-postgresql96-postgresql-0:9.6.10-1.el6 | Fixed | RHSA-2018:2566 |
| Red Hat Software Collections for Red Hat Enterprise Linux 7 | rh-postgresql95-postgresql-0:9.5.14-1.el7 | Fixed | RHSA-2018:2511 |
| Red Hat Software Collections for Red Hat Enterprise Linux 7 | rh-postgresql96-postgresql-0:9.6.10-1.el7 | Fixed | RHSA-2018:2566 |
| Red Hat Software Collections for Red Hat Enterprise Linux 7.3 EUS | rh-postgresql95-postgresql-0:9.5.14-1.el7 | Fixed | RHSA-2018:2511 |
| Red Hat Software Collections for Red Hat Enterprise Linux 7.3 EUS | rh-postgresql96-postgresql-0:9.6.10-1.el7 | Fixed | RHSA-2018:2566 |
| Red Hat Software Collections for Red Hat Enterprise Linux 7.4 EUS | rh-postgresql95-postgresql-0:9.5.14-1.el7 | Fixed | RHSA-2018:2511 |
| Red Hat Software Collections for Red Hat Enterprise Linux 7.4 EUS | rh-postgresql96-postgresql-0:9.6.10-1.el7 | Fixed | RHSA-2018:2566 |
| Red Hat Software Collections for Red Hat Enterprise Linux 7.5 EUS | rh-postgresql95-postgresql-0:9.5.14-1.el7 | Fixed | RHSA-2018:2511 |
| Red Hat Software Collections for Red Hat Enterprise Linux 7.5 EUS | rh-postgresql96-postgresql-0:9.6.10-1.el7 | Fixed | RHSA-2018:2566 |
| Red Hat Enterprise Linux 5 | postgresql | Not affected | n/a |
| Red Hat Enterprise Linux 5 | postgresql84 | Not affected | n/a |
| Red Hat Enterprise Linux 6 | postgresql | Not affected | n/a |
| Red Hat Enterprise Linux 7 | postgresql | Not affected | n/a |
| Red Hat Satellite 5 | postgresql92-postgresql | Not affected | n/a |
| Red Hat Software Collections | rh-postgresql94-postgresql | Not affected | n/a |
No package ranges for this CVE.
Remediation
Red Hat statement
This issue affects the versions of rh-postgresql95-postgresql, and rh-postgresql96-postgresql as shipped with Red Hat Software Collections 3. Red Hat Product Security has rated this issue as having Low security impact. A future update may address this issue. For additional information, refer to the Issue Severity Classification: https://access.redhat.com/security/updates/classification/.
Metrics
No CVSS v4.0 score for this CVE.
No CVSS v3.1 score for this CVE.
CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N
1 other source (Red Hat) ▾
CVSS:3.0/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:N/A:N
AV:N/AC:L/Au:S/C:P/I:N/A:N
This CVE is not in the KEV list.
No CISA SSVC assessment for this CVE yet.
Estimated probability of exploitation in the wild in the next 30 days (FIRST EPSS). As of Oct 1, 2026.
Score over time
2021–2026- EPSS v1
- EPSS v2
- EPSS v3
- EPSS v4
- EPSS v5
Percentile over time
- EPSS v1
- EPSS v2
- EPSS v3
- EPSS v4
- EPSS v5
Table of values (32 key points)
Flat stretches are collapsed; showing up to 120 newest points.
| Date | Score | Percentile | Model |
|---|---|---|---|
| Oct 1, 2026 | 6.32% (0.06324) | 93.41th | v5 (v2026.06.15) |
| Jun 15, 2026 | 6.32% (0.06324) | 92.70th | v5 (v2026.06.15) |
| May 26, 2026 | 32.99% (0.32989) | 96.96th | v4 (v2025.03.14) |
| Apr 12, 2026 | 27.11% (0.27111) | 96.38th | v4 (v2025.03.14) |
| Sep 20, 2025 | 30.23% (0.30234) | 96.54th | v4 (v2025.03.14) |
| Aug 30, 2025 | 28.76% (0.28762) | 96.37th | v4 (v2025.03.14) |
| Jun 8, 2025 | 34.01% (0.34010) | 96.73th | v4 (v2025.03.14) |
| Jun 6, 2025 | 35.08% (0.35084) | 96.81th | v4 (v2025.03.14) |
| Apr 10, 2025 | 11.28% (0.11281) | 92.91th | v4 (v2025.03.14) |
| Mar 30, 2025 | 10.19% (0.10191) | 92.40th | v4 (v2025.03.14) |
| Mar 29, 2025 | 36.61% (0.36615) | 95.59th | v4 (v2025.03.14) |
| Mar 28, 2025 | 10.19% (0.10191) | 92.40th | v4 (v2025.03.14) |
| Mar 27, 2025 | 36.61% (0.36615) | 96.59th | v4 (v2025.03.14) |
| Mar 20, 2025 | 10.19% (0.10191) | 92.49th | v4 (v2025.03.14) |
| Mar 19, 2025 | 36.61% (0.36615) | 96.66th | v4 (v2025.03.14) |
| Mar 17, 2025 | 10.19% (0.10191) | 92.55th | v4 (v2025.03.14) |
| Dec 17, 2024 | 0.29% (0.00295) | 68.82th | v3 (v2023.03.01) |
| Jul 10, 2024 | 0.67% (0.00667) | 79.90th | v3 (v2023.03.01) |
| Feb 8, 2024 | 0.26% (0.00256) | 64.44th | v3 (v2023.03.01) |
| Jun 18, 2023 | 0.26% (0.00256) | 62.15th | v3 (v2023.03.01) |
| May 25, 2023 | 0.28% (0.00280) | 63.74th | v3 (v2023.03.01) |
| May 8, 2023 | 0.40% (0.00397) | 69.54th | v3 (v2023.03.01) |
| Apr 15, 2023 | 0.36% (0.00363) | 68.08th | v3 (v2023.03.01) |
| Mar 7, 2023 | 0.38% (0.00375) | 68.48th | v3 (v2023.03.01) |
| Mar 6, 2023 | 1.03% (0.01034) | 41.69th | v2 (v2022.01.01) |
| Sep 10, 2022 | 1.03% (0.01034) | 39.91th | v2 (v2022.01.01) |
| Apr 1, 2022 | 1.03% (0.01034) | 37.91th | v2 (v2022.01.01) |
| Feb 4, 2022 | 1.03% (0.01034) | 20.32th | v2 (v2022.01.01) |
| Feb 3, 2022 | 1.66% (0.01659) | 34.20th | v1 |
| Jan 6, 2022 | 1.66% (0.01659) | 33.50th | v1 |
| Sep 1, 2021 | 1.66% (0.01659) | 73.96th | v1 |
| Apr 14, 2021 | 1.66% (0.01659) | 0.00th | v1 |
References (11)
- http://www.securityfocus.com/bid/101781 vdb-entryx_refsource_BIDThird Party AdvisoryVDB Entry
- http://www.securitytracker.com/id/1039752 vdb-entryx_refsource_SECTRACKThird Party AdvisoryVDB Entry
- https://access.redhat.com/errata/RHSA-2018:2511 vendor-advisoryx_refsource_REDHAT
- https://access.redhat.com/errata/RHSA-2018:2566 vendor-advisoryx_refsource_REDHAT
- https://access.redhat.com/security/cve/CVE-2017-15099 Vendor Advisory
- https://bugzilla.redhat.com/show_bug.cgi?id=1508823 Issue Tracking
- https://nvd.nist.gov/vuln/detail/CVE-2017-15099
- https://www.cve.org/CVERecord?id=CVE-2017-15099
- https://www.debian.org/security/2017/dsa-4028 vendor-advisoryx_refsource_DEBIANIssue TrackingThird Party Advisory
- https://www.postgresql.org/about/news/1801/ x_refsource_CONFIRMIssue TrackingVendor Advisory
- https://www.postgresql.org/support/security/ x_refsource_MISCIssue TrackingVendor Advisory
| Link | Providers | Tags |
|---|---|---|
| http://www.securityfocus.com/bid/101781 | vdb-entryx_refsource_BIDThird Party AdvisoryVDB Entry | |
| http://www.securitytracker.com/id/1039752 | vdb-entryx_refsource_SECTRACKThird Party AdvisoryVDB Entry | |
| https://access.redhat.com/errata/RHSA-2018:2511 | vendor-advisoryx_refsource_REDHAT | |
| https://access.redhat.com/errata/RHSA-2018:2566 | vendor-advisoryx_refsource_REDHAT | |
| https://access.redhat.com/security/cve/CVE-2017-15099 | Vendor Advisory | |
| https://bugzilla.redhat.com/show_bug.cgi?id=1508823 | Issue Tracking | |
| https://nvd.nist.gov/vuln/detail/CVE-2017-15099 | ||
| https://www.cve.org/CVERecord?id=CVE-2017-15099 | ||
| https://www.debian.org/security/2017/dsa-4028 | vendor-advisoryx_refsource_DEBIANIssue TrackingThird Party Advisory | |
| https://www.postgresql.org/about/news/1801/ | x_refsource_CONFIRMIssue TrackingVendor Advisory | |
| https://www.postgresql.org/support/security/ | x_refsource_MISCIssue TrackingVendor Advisory |
Change history (0)
No recorded changes yet.