Re: Allow CURRENT_ROLE in GRANTED BY

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Allow CURRENT_ROLE in GRANTED BY
Дата
Msg-id cc12f3fc-9fb1-71dc-1b51-1edf65f9e5c2@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: Allow CURRENT_ROLE in GRANTED BY  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Ответы Re: Allow CURRENT_ROLE in GRANTED BY  (Asif Rehman <asifr.rehman@gmail.com>)
Re: Allow CURRENT_ROLE in GRANTED BY  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
On 2020-06-29 14:47, Peter Eisentraut wrote:
> 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.

Here is another patch that also makes comprehensive updates to the 
rolenames tests under src/test/modules/unsafe_tests/.

I think this should now cover all the required ancillary changes.

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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Implement UNLOGGED clause for COPY FROM
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: use pg_get_functiondef() in pg_dump