Fix priv checks for ALTER <object> DEPENDS ON EXTENSION

Alvaro Herrera <alvherre@alvh.no-ip.org>

Commit: e8b8eb937642f56725d4bc025ea7fa57caf6992c
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2020-02-10T15:06:25Z
Releases: 9.6.17
Fix priv checks for ALTER <object> DEPENDS ON EXTENSION

Marking an object as dependant on an extension did not have any
privilege check whatsoever; this allowed any user to mark objects as
droppable by anyone able to DROP EXTENSION, which could be used to cause
system-wide havoc.  Disallow by checking that the calling user owns the
mentioned object.

(No constraints are placed on the extension.)

Security: CVE-2020-1720
Reported-by: Tom Lane
Discussion: 31605.1566429043@sss.pgh.pa.us

Files

PathChange+/−
src/backend/commands/alter.c modified +13 −0