Re: Allow CURRENT_ROLE in GRANTED BY - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Allow CURRENT_ROLE in GRANTED BY
Date
Msg-id 13369949-9e86-9214-8952-a74befaea41d@2ndquadrant.com
Whole thread Raw
In response to Re: Allow CURRENT_ROLE in GRANTED BY  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: Allow CURRENT_ROLE in GRANTED BY  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
On 2020-06-24 23:08, Alvaro Herrera wrote:
> On 2020-Jun-24, Peter Eisentraut wrote:
> 
>> I was checking some loose ends in SQL conformance, when I noticed: We
>> support GRANT role ... GRANTED BY CURRENT_USER, but we don't support
>> CURRENT_ROLE in that place, even though in PostgreSQL they are equivalent.
>> Here is a trivial patch to add that.
> 
> Hmm, since this adds to RoleSpec, this change makes every place that
> uses that production also take CURRENT_ROLE, so we'd need to document in
> all those places.  For example, alter_role.sgml, create_schema.sgml,
> etc.

Good point.  Here is an updated patch that updates all the documentation 
places where CURRENT_USER is mentioned.

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

Attachment

pgsql-hackers by date:

Previous
From: "higuchi.daisuke@fujitsu.com"
Date:
Subject: RE: [Bug fix]There is the case archive_timeout parameter is ignoredafter recovery works.
Next
From: Masahiko Sawada
Date:
Subject: Re: xid wraparound danger due to INDEX_CLEANUP false