Fix priv checks for ALTER <object> DEPENDS ON EXTENSION
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Mon, 10 Feb 2020 14:47:09 +0000 (11:47 -0300)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Mon, 10 Feb 2020 14:47:09 +0000 (11:47 -0300)
commitb048f558dd7c26a0c630a2cff29d3d8981eaf6b9
tree3d3d31bc4512c4562dc2abd8d86d771a5007614f
parent4e818866e57aa9ec13821fd36a2ff60e00e6dea6
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
src/backend/commands/alter.c