Horton

Re: Allow CURRENT_ROLE in GRANTED BY

Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

View thread View on postgr.es
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2020-09-17T10:02:35Z
Lists: pgsql-hackers 
On 2020-09-11 22:05, Alvaro Herrera wrote:
> On 2020-Aug-26, Peter Eisentraut wrote:
> 
>> Here is another patch that also makes comprehensive updates to the rolenames
>> tests under src/test/modules/unsafe_tests/.
> 
> Looks good to me.  You need to DROP ROLE "current_role" at the bottom of
> rolenames.sql, though (as well as DROP OWNED BY, I suppose.)
> 
>> I think this should now cover all the required ancillary changes.
> 
> \o/
> 

committed


-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

  1. Fix GRANTED BY support in REVOKE ROLE statements

  2. Allow GRANTED BY clause in normal GRANT and REVOKE statements

  3. Try to stabilize output from rolenames regression test.

  4. Allow CURRENT_ROLE where CURRENT_USER is accepted