Missing authorization in PostgreSQL logical decoding allows a non-superuser holding REPLICATION privilege to dlopen any file visible to the operating system account running the server, via the choice of logical decoding plugin. This in turn runs arbitrary code as that account. Versions before PostgreSQL 18.6, 17.11, 16.15, 15.19, and 14.24 are affected.
Weakness
The product does not perform an authorization check when an actor attempts to access a resource or perform an action.
Affected Software
| Name | Vendor | Start Version | End Version |
|---|---|---|---|
| Postgresql | Postgresql | 14.0 (including) | 14.24 (excluding) |
| Postgresql | Postgresql | 15.0 (including) | 15.19 (excluding) |
| Postgresql | Postgresql | 16.0 (including) | 16.15 (excluding) |
| Postgresql | Postgresql | 17.0 (including) | 17.11 (excluding) |
| Postgresql | Postgresql | 18.0 (including) | 18.5 (excluding) |
| Red Hat Enterprise Linux 10 | RedHat | postgresql18-0:18.6-1.el10_2 | * |
| Red Hat Enterprise Linux 10 | RedHat | postgresql16-0:16.15-1.el10_2 | * |
| Red Hat Enterprise Linux 8 | RedHat | postgresql:16-8100020260910192321.489197e6 | * |
| Red Hat Enterprise Linux 8 | RedHat | postgresql:15-8100020260906175012.489197e6 | * |
| Red Hat Enterprise Linux 8 | RedHat | postgresql:12-8100020260917081510.489197e6 | * |
| Red Hat Enterprise Linux 8.8 Telecommunications Update Service | RedHat | postgresql:15-8080020260921162003.63b34585 | * |
| Red Hat Enterprise Linux 8.8 Update Services for SAP Solutions | RedHat | postgresql:15-8080020260921162003.63b34585 | * |
| Red Hat Enterprise Linux 9 | RedHat | postgresql:16-9080020260907191505.rhel9 | * |
| Red Hat Enterprise Linux 9 | RedHat | postgresql:18-9080020260914093252.rhel9 | * |
| Red Hat Enterprise Linux 9 | RedHat | postgresql-0:13.23-6.el9_8 | * |
| Red Hat Enterprise Linux 9 | RedHat | postgresql:15-9080020260903073937.rhel9 | * |
| Red Hat Enterprise Linux 9.2 Update Services for SAP Solutions | RedHat | postgresql:15-9020020260917092006.rhel9 | * |
| Red Hat Enterprise Linux 9.4 Update Services for SAP Solutions | RedHat | postgresql:15-9040020260917091622.rhel9 | * |
| Red Hat Enterprise Linux 9.4 Update Services for SAP Solutions | RedHat | postgresql:16-9040020260922062609.rhel9 | * |
| Red Hat Enterprise Linux 9.6 Extended Update Support | RedHat | postgresql:15-9060020260917102335.rhel9 | * |
| Red Hat Enterprise Linux 9.6 Extended Update Support | RedHat | postgresql:16-9060020260921091101.rhel9 | * |
| Red Hat Update Infrastructure 5 | RedHat | rhui5/rhua-rhel9:1790242004 | * |
| Postgresql-10 | Ubuntu | upstream | * |
| Postgresql-12 | Ubuntu | upstream | * |
| Postgresql-14 | Ubuntu | jammy | * |
| Postgresql-16 | Ubuntu | noble | * |
| Postgresql-18 | Ubuntu | devel | * |
| Postgresql-18 | Ubuntu | resolute | * |
| Postgresql-9.3 | Ubuntu | upstream | * |
| Postgresql-9.5 | Ubuntu | upstream | * |
Potential Mitigations
- Divide the product into anonymous, normal, privileged, and administrative areas. Reduce the attack surface by carefully mapping roles with data and functionality. Use role-based access control (RBAC) [REF-229] to enforce the roles at the appropriate boundaries.
- Note that this approach may not protect against horizontal authorization, i.e., it will not protect a user from attacking others with the same role.
- Use a vetted library or framework that does not allow this weakness to occur or provides constructs that make this weakness easier to avoid.
- For example, consider using authorization frameworks such as the JAAS Authorization Framework [REF-233] and the OWASP ESAPI Access Control feature [REF-45].
- For web applications, make sure that the access control mechanism is enforced correctly at the server side on every page. Users should not be able to access any unauthorized functionality or information by simply requesting direct access to that page.
- One way to do this is to ensure that all pages containing sensitive information are not cached, and that all such pages restrict access to requests that are accompanied by an active and authenticated session token associated with a user who has the required permissions to access that page.