PT-2019-3231

CVE-2019-10208

·

Published

2019-08-07

·

Updated

2026-09-18

Description by

CVSS 2.0
9.0
High
MetricsAV:N/AC:L/Au:S/C:C/I:C/A:C
Name of the Vulnerable Software and Affected Versions postgresql versions 9.4.x before 9.4.24 postgresql versions 9.5.x before 9.5.19 postgresql versions 9.6.x before 9.6.15 postgresql versions 10.x before 10.10 postgresql versions 11.x before 11.5
Description A flaw in postgresql allows arbitrary SQL statements to be executed given a suitable SECURITY DEFINER function. An attacker with EXECUTE permission on the function can execute arbitrary SQL as the owner of the function. The vulnerability is related to the lack of protection of the SQL query structure in the SECURITY DEFINER function of the PostgreSQL database management system. Exploitation of the vulnerability can allow a remote attacker to execute arbitrary SQL commands.
Recommendations For postgresql versions 9.4.x before 9.4.24, update to version 9.4.24 or later. For postgresql versions 9.5.x before 9.5.19, update to version 9.5.19 or later. For postgresql versions 9.6.x before 9.6.15, update to version 9.6.15 or later. For postgresql versions 10.x before 10.10, update to version 10.10 or later. For postgresql versions 11.x before 11.5, update to version 11.5 or later. As a temporary workaround, consider restricting EXECUTE permission on SECURITY DEFINER functions to minimize the risk of exploitation.
Exploitability
Fix
Impacts
Researchers
Vendors
Affected products
Related identifiers
ALT-PU-2019-2383
ALT-PU-2019-2384
ALT-PU-2019-2385
ALT-PU-2019-2386
ALT-PU-2019-2387
ALT-PU-2019-2388
ALT-PU-2019-2425
ALT-PU-2019-2426
ALT-PU-2019-2427
ALT-PU-2019-2428
ALT-PU-2019-2429
ALT-PU-2019-2430
CESA-2020_3669
CESA-2020_5619
CESA-2021_1512
CLEANSTART-2026-FW42039
CLEANSTART-2026-HJ04971
CLEANSTART-2026-UB56862
DLA-1874-1
DSA-4492-1
DSA-4493-1
MGASA-2019-0225
OPENSUSE-SU-2019:2062-1
OPENSUSE-SU-2019_2062-1
OPENSUSE-SU-2020:1227-1
OPENSUSE-SU-2020_1227-1
OPENSUSE-SU-2024:11184-1
OPENSUSE-SU-2024:11185-1
RHSA-2020:0980
RHSA-2020:3669
RHSA-2020_3669
RHSA-2020:4295
RHSA-2020:5619
RHSA-2020_5619
RHSA-2020:5661
RHSA-2020:5664
RHSA-2021:0164
RHSA-2021:0166
RHSA-2021:0167
RHSA-2021:1512
RHSA-2021_1512
SUSE-SU-2019:2158-1
SUSE-SU-2019_2158-1
SUSE-SU-2019:2159-1
SUSE-SU-2019_2159-1
SUSE-SU-2019:2228-1
SUSE-SU-2019_2228-1
SUSE-SU-2019:2707-1
SUSE-SU-2019_2707-1
USN-4090-1
Found an issue in the description? Have something to add? Feel free to write us 👾