Re: Allow placeholders in ALTER ROLE w/o superuser

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Allow placeholders in ALTER ROLE w/o superuser
Дата
Msg-id 2271312.1668807199@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Allow placeholders in ALTER ROLE w/o superuser  (Alexander Korotkov <aekorotkov@gmail.com>)
Ответы Re: Allow placeholders in ALTER ROLE w/o superuser
Re: Allow placeholders in ALTER ROLE w/o superuser
Список pgsql-hackers
Alexander Korotkov <aekorotkov@gmail.com> writes:
> This makes sense.  But do we really need to store the OID of the role?
>  validate_option_array_item() already checks if the placeholder option
> passes validation for PGC_SUSET.  So, we can just save a flag
> indicating that this check was not successful.  If so, then the value
> stored can be only used for PGC_USERSET.  Do you think this would be
> correct?

Meh ... doesn't seem like much of an improvement.  You still need
to store something that's not there now.  This also seems to require
some shaky assumptions about decisions having been made when storing
still being valid later on.  Given the possibility of granting or
revoking permissions for SET, I think we don't really want it to act
that way.

            regards, tom lane



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

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: Re: Allow placeholders in ALTER ROLE w/o superuser
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: fix stats_fetch_consistency value in postgresql.conf.sample