ALTER ROLE documentation improvement

Поиск
Список
Период
Сортировка
От Yurii Rashkovskii
Тема ALTER ROLE documentation improvement
Дата
Msg-id CA+RLCQzSx_eTC2Fch0EzeNHD3zFUcPvBYOoB+pPScFLch1DEQw@mail.gmail.com
обсуждение исходный текст
Ответы Re: ALTER ROLE documentation improvement  (Nathan Bossart <nathandbossart@gmail.com>)
Список pgsql-hackers
Hi,

It appears that 16.0 improved some of the checks in ALTER ROLE. Previously, it was possible to do the following (assuming current_user is a bootstrap user):

```
ALTER ROLE current_user NOSUPERUSER
```

As of 16.0, this produces an error:

```
ERROR:  permission denied to alter role
DETAIL:  The bootstrap user must have the SUPERUSER attribute.
```

The attached patch documents this behavior by providing a bit more clarification to the following statement:

"Database superusers can change any of these settings for any role."


--
Y.

Вложения

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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: Faster "SET search_path"
Следующее
От: stepan rutz
Дата:
Сообщение: Re: Detoasting optionally to make Explain-Analyze less misleading