pgsql: Disallow SET SESSION AUTHORIZATION pg_*

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Disallow SET SESSION AUTHORIZATION pg_*
Date: 2016-04-14 01:31:36
Message-ID: E1aqW88-0007Pg-Ec@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Disallow SET SESSION AUTHORIZATION pg_*

As part of reserving the pg_* namespace for default roles and in line
with SET ROLE and other previous efforts, disallow settings the role
to a default/reserved role using SET SESSION AUTHORIZATION.

These checks and restrictions on what is allowed regarding default /
reserved roles are under debate, but it seems prudent to ensure that
the existing checks at least cover the intended cases while the
debate rages on. On me to clean it up if the consensus decision is
to remove these checks.

Branch
------
master

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

Modified Files
--------------
src/backend/commands/variable.c | 4 ++++
1 file changed, 4 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Stephen Frost 2016-04-14 01:42:10 Re: pgsql: Fix pg_dump so pg_upgrade'ing an extension with simple opfamilie
Previous Message Andres Freund 2016-04-14 00:41:12 pgsql: Add required database and origin filtering for logical messages.