Re: Add --{no-,}bypassrls flags to createuser

Поиск
Список
Период
Сортировка
От Kyotaro Horiguchi
Тема Re: Add --{no-,}bypassrls flags to createuser
Дата
Msg-id 20220413.154625.2001259434473326066.horikyota.ntt@gmail.com
обсуждение исходный текст
Ответ на Add --{no-,}bypassrls flags to createuser  (Shinya Kato <Shinya11.Kato@oss.nttdata.com>)
Ответы Re: Add --{no-,}bypassrls flags to createuser
Список pgsql-hackers
At Wed, 13 Apr 2022 14:51:35 +0900, Shinya Kato <Shinya11.Kato@oss.nttdata.com> wrote in 
> Hi,
> 
> Add --{no-,}bypassrls flags to createuser.
> The following is an example of execution.
> --
> $ createuser a --bypassrls
> $ psql -c "\du a"
>            List of roles
>  Role name | Attributes | Member of
> -----------+------------+-----------
>  a         | Bypass RLS | {}
> 
> -- 
> 
> Do you think?

It is sensible to rig createuser command with full capability of
CREATE ROLE is reasonable.

Only --replication is added by commit 9b8aff8c19 (2010) since
8ae0d476a9 (2005). BYPASSRLS and NOBYPASSRLS were introduced by
491c029dbc (2014) but it seems to have forgotten to add the
corresponding createuser options.

By a quick search, found a few other CREATE ROLE optinos that are not
supported by createuser.

VALID UNTIL
ROLE  (IN ROLE is -g/--role)
ADMIN

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center



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

Предыдущее
От: Antonin Houska
Дата:
Сообщение: Re: Temporary file access API
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: CLUSTER on partitioned index