The ALTER ... DEPENDS ON EXTENSION sub-commands do not perform authorization checks, which can allow an unprivileged user to drop any function, procedure, materialized view, index, or trigger under certain conditions. This attack is possible if an administrator has installed an extension and an unprivileged user can CREATE, or an extension owner either executes DROP EXTENSION predictably or can be convinced to execute DROP EXTENSION.
The PostgreSQL project thanks Tom Lane for reporting this problem.
| Affected Version | Fixed In | Fix Published |
|---|---|---|
| 12 | 12.2 | Feb. 13, 2020 |
| 11 | 11.7 | Feb. 13, 2020 |
| 10 | 10.12 | Feb. 13, 2020 |
| 9.6 | 9.6.17 | Feb. 13, 2020 |
For more information about PostgreSQL versioning, please visit the versioning page.
| Overall Score | 3.1 |
|---|---|
| Component | core server |
| Vector | AV:N/AC:H/PR:L/UI:N/S:U/C:N/I:L/A:N |
If you wish to report a new security vulnerability in PostgreSQL, please send an email to security@postgresql.org.
For reporting non-security bugs, please see the Report a Bug page.