pgsql: Prevent privilege escalation in explicit calls to PL validators. - Mailing list pgsql-committers

From Noah Misch
Subject pgsql: Prevent privilege escalation in explicit calls to PL validators.
Date
Msg-id E1WFPlR-0000fl-Nk@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Prevent privilege escalation in explicit calls to PL validators.

The primary role of PL validators is to be called implicitly during
CREATE FUNCTION, but they are also normal functions that a user can call
explicitly.  Add a permissions check to each validator to ensure that a
user cannot use explicit validator calls to achieve things he could not
otherwise achieve.  Back-patch to 8.4 (all supported versions).
Non-core procedural language extensions ought to make the same two-line
change to their own validators.

Andres Freund, reviewed by Tom Lane and Noah Misch.

Security: CVE-2014-0061

Branch
------
REL9_3_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/fc4a04a3c4f49ac8a74241401ffd5118c4d00842

Modified Files
--------------
doc/src/sgml/plhandler.sgml         |    5 ++-
src/backend/catalog/pg_proc.c       |    9 ++++
src/backend/commands/functioncmds.c |    1 -
src/backend/utils/fmgr/fmgr.c       |   84 +++++++++++++++++++++++++++++++++++
src/include/fmgr.h                  |    1 +
src/pl/plperl/plperl.c              |    4 ++
src/pl/plpgsql/src/pl_handler.c     |    3 ++
src/pl/plpython/plpy_main.c         |    4 ++
8 files changed, 109 insertions(+), 2 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Document risks of "make check" in the regression testing instruc
Next
From: Tom Lane
Date:
Subject: pgsql: Last-minute updates for release notes.