]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Document search_path security with untrusted dbowner or CREATEROLE.
authorNoah Misch <noah@leadboat.com>
Sun, 8 Dec 2019 19:06:26 +0000 (11:06 -0800)
committerNoah Misch <noah@leadboat.com>
Sun, 8 Dec 2019 19:06:30 +0000 (11:06 -0800)
commit3056258149c1aea7341a4d81bd502e1a1c8198a6
tree0f10f6eec0d54c5088d8b247473284dc9ce1558c
parenta2fdeb7863a684b661b0fcbaf90f00595be11bd0
Document search_path security with untrusted dbowner or CREATEROLE.

Commit 5770172cb0c9df9e6ce27c507b449557e5b45124 wrote, incorrectly, that
certain schema usage patterns are secure against CREATEROLE users and
database owners.  When an untrusted user is the database owner or holds
CREATEROLE privilege, a query is secure only if its session started with
SELECT pg_catalog.set_config('search_path', '', false) or equivalent.
Back-patch to 9.4 (all supported versions).

Discussion: https://postgr.es/m/20191013013512.GC4131753@rfd.leadboat.com
doc/src/sgml/ddl.sgml