Vulnerability in core server (CVE-2022-2625)

Extension scripts replace objects not belonging to the extension

Some extensions use CREATE OR REPLACE or CREATE IF NOT EXISTS commands. Some don’t adhere to the documented rule to target only objects known to be extension members already. An attack requires permission to create non-temporary objects in at least one schema, ability to lure or wait for an administrator to create or update an affected extension in that schema, and ability to lure or wait for a victim to use the object targeted in CREATE OR REPLACE or CREATE IF NOT EXISTS. Given all three prerequisites, the attacker can run arbitrary code as the victim role, which may be a superuser. Known-affected extensions include both PostgreSQL-bundled and non-bundled extensions. PostgreSQL is blocking this attack in the core server, so there’s no need to modify individual extensions.

The PostgreSQL project thanks Sven Klemm for reporting this problem.