A vulnerability was found in PostgreSQL versions 11.x up to excluding 11.3, 10.x up to excluding 10.8, 9.6.x up to, excluding 9.6.13, 9.5.x up to, excluding 9.5.17. PostgreSQL maintains column statistics for tables. Certain statistics, such as histograms and lists of most common values, contain values taken from the column. PostgreSQL does not evaluate row security policies before consulting those statistics during query planning; an attacker can exploit this to read the most common values of certain columns. Affected columns are those for which the attacker has SELECT privilege and for which, in an ordinary query, row-level security prunes the set of rows visible to the attacker.
Weakness
The product does not restrict or incorrectly restricts access to a resource from an unauthorized actor.
Affected Software
| Name | Vendor | Start Version | End Version |
|---|---|---|---|
| Postgresql | Postgresql | 9.5.0 (including) | 9.5.17 (excluding) |
| Postgresql | Postgresql | 9.6.0 (including) | 9.6.13 (excluding) |
| Postgresql | Postgresql | 10.0 (including) | 10.8 (excluding) |
| Postgresql | Postgresql | 11.0 (including) | 11.3 (excluding) |
| Red Hat Enterprise Linux 8 | RedHat | postgresql:10-8020020200825115746.4cda2c84 | * |
| Red Hat Enterprise Linux 8 | RedHat | postgresql:9.6-8030020201201133334.229f0a1c | * |
| Red Hat Enterprise Linux 8.0 Update Services for SAP Solutions | RedHat | postgresql:9.6-8000020201214122017.f8e95b4e | * |
| Red Hat Enterprise Linux 8.0 Update Services for SAP Solutions | RedHat | postgresql:10-8000020201214113918.f8e95b4e | * |
| Red Hat Enterprise Linux 8.1 Extended Update Support | RedHat | postgresql:10-8010020201214112129.c27ad7f8 | * |
| Red Hat Enterprise Linux 8.1 Extended Update Support | RedHat | postgresql:9.6-8010020201214134447.c27ad7f8 | * |
| Red Hat Enterprise Linux 8.2 Extended Update Support | RedHat | postgresql:9.6-8020020201201133334.4cda2c84 | * |
| Red Hat Software Collections for Red Hat Enterprise Linux 7 | RedHat | rh-postgresql10-postgresql-0:10.12-2.el7 | * |
| Red Hat Software Collections for Red Hat Enterprise Linux 7 | RedHat | rh-postgresql96-postgresql-0:9.6.19-1.el7 | * |
| Red Hat Software Collections for Red Hat Enterprise Linux 7.5 EUS | RedHat | rh-postgresql10-postgresql-0:10.12-2.el7 | * |
| Red Hat Software Collections for Red Hat Enterprise Linux 7.6 EUS | RedHat | rh-postgresql10-postgresql-0:10.12-2.el7 | * |
| Red Hat Software Collections for Red Hat Enterprise Linux 7.6 EUS | RedHat | rh-postgresql96-postgresql-0:9.6.19-1.el7 | * |
| Red Hat Software Collections for Red Hat Enterprise Linux 7.7 EUS | RedHat | rh-postgresql10-postgresql-0:10.12-2.el7 | * |
| Red Hat Software Collections for Red Hat Enterprise Linux 7.7 EUS | RedHat | rh-postgresql96-postgresql-0:9.6.19-1.el7 | * |
| Postgresql-10 | Ubuntu | bionic | * |
| Postgresql-10 | Ubuntu | cosmic | * |
| Postgresql-10 | Ubuntu | esm-infra/bionic | * |
| Postgresql-10 | Ubuntu | upstream | * |
| Postgresql-11 | Ubuntu | disco | * |
| Postgresql-11 | Ubuntu | upstream | * |
| Postgresql-9.5 | Ubuntu | esm-infra/xenial | * |
| Postgresql-9.5 | Ubuntu | upstream | * |
| Postgresql-9.5 | Ubuntu | xenial | * |
Extended Description
Access control involves the use of several protection mechanisms such as:
When any mechanism is not applied or otherwise fails, attackers can compromise the security of the product by gaining privileges, reading sensitive information, executing commands, evading detection, etc. There are two distinct behaviors that can introduce access control weaknesses:
Potential Mitigations
- Compartmentalize the system to have “safe” areas where trust boundaries can be unambiguously drawn. Do not allow sensitive data to go outside of the trust boundary and always be careful when interfacing with a compartment outside of the safe area.
- Ensure that appropriate compartmentalization is built into the system design, and the compartmentalization allows for and reinforces privilege separation functionality. Architects and designers should rely on the principle of least privilege to decide the appropriate time to use privileges and the time to drop privileges.
Related Attack Patterns
- https://cwe.mitre.org/data/definitions/19.html
- https://cwe.mitre.org/data/definitions/441.html
- https://cwe.mitre.org/data/definitions/478.html
- https://cwe.mitre.org/data/definitions/479.html
- https://cwe.mitre.org/data/definitions/502.html
- https://cwe.mitre.org/data/definitions/503.html
- https://cwe.mitre.org/data/definitions/536.html
- https://cwe.mitre.org/data/definitions/546.html
- https://cwe.mitre.org/data/definitions/550.html
- https://cwe.mitre.org/data/definitions/551.html
- https://cwe.mitre.org/data/definitions/552.html
- https://cwe.mitre.org/data/definitions/556.html
- https://cwe.mitre.org/data/definitions/558.html
- https://cwe.mitre.org/data/definitions/562.html
- https://cwe.mitre.org/data/definitions/563.html
- https://cwe.mitre.org/data/definitions/564.html
- https://cwe.mitre.org/data/definitions/578.html
References
- http://lists.opensuse.org/opensuse-security-announce/2020-08/msg00043.html
- https://bugzilla.redhat.com/show_bug.cgi?id=CVE-2019-10130
- https://security.gentoo.org/glsa/202003-03
- https://www.postgresql.org/about/news/1939/
- http://lists.opensuse.org/opensuse-security-announce/2020-08/msg00043.html
- https://bugzilla.redhat.com/show_bug.cgi?id=CVE-2019-10130
- https://security.gentoo.org/glsa/202003-03
- https://www.postgresql.org/about/news/1939/