Re: Add --{no-,}bypassrls flags to createuser - Mailing list pgsql-hackers

From Kyotaro Horiguchi
Subject Re: Add --{no-,}bypassrls flags to createuser
Date
Msg-id 20220413.154625.2001259434473326066.horikyota.ntt@gmail.com
Whole thread Raw
In response to Add --{no-,}bypassrls flags to createuser  (Shinya Kato <Shinya11.Kato@oss.nttdata.com>)
Responses Re: Add --{no-,}bypassrls flags to createuser  (Michael Paquier <michael@paquier.xyz>)
List 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 by date:

Previous
From: Antonin Houska
Date:
Subject: Re: Temporary file access API
Next
From: Michael Paquier
Date:
Subject: Re: CLUSTER on partitioned index