RE: New predefined roles- 'pg_read/write_all_data'

2021-09-05 Thread Shinoda, Noriyoshi (PN Japan FSIP)
; gkokola...@pm.me; pgsql-hackers@lists.postgresql.org Subject: Re: New predefined roles- 'pg_read/write_all_data' Greetings, On Sun, Sep 5, 2021 at 07:43 Shinoda, Noriyoshi (PN Japan FSIP) mailto:noriyoshi.shin...@hpe.com>> wrote: I have tested this new feature with PostgreSQL 14 Beta

Re: New predefined roles- 'pg_read/write_all_data'

2021-09-05 Thread Stephen Frost
Greetings, On Sun, Sep 5, 2021 at 07:43 Shinoda, Noriyoshi (PN Japan FSIP) < noriyoshi.shin...@hpe.com> wrote: > I have tested this new feature with PostgreSQL 14 Beta 3 environment. > I created a user granted with pg_write_all_data role and executed UPDATE > and DELETE statements on tables owned

RE: New predefined roles- 'pg_read/write_all_data'

2021-09-05 Thread Shinoda, Noriyoshi (PN Japan FSIP)
oshi Shinoda -Original Message- From: Stephen Frost [mailto:sfr...@snowman.net] Sent: Saturday, August 28, 2021 7:34 AM To: Michael Banck Cc: gkokola...@pm.me; Anastasia Lubennikova ; pgsql-hackers@lists.postgresql.org Subject: Re: New predefined roles- 'pg_read/write_all_data'

Re: New predefined roles- 'pg_read/write_all_data'

2021-08-27 Thread Stephen Frost
Greetings, * Michael Banck (michael.ba...@credativ.de) wrote: > On Thu, Apr 01, 2021 at 04:00:06PM -0400, Stephen Frost wrote: > > diff --git a/doc/src/sgml/user-manag.sgml b/doc/src/sgml/user-manag.sgml > > index d171b13236..fe0bdb7599 100644 > > --- a/doc/src/sgml/user-manag.sgml > > +++ b/doc/s

Re: New predefined roles- 'pg_read/write_all_data'

2021-04-07 Thread Michael Banck
Hi, On Thu, Apr 01, 2021 at 04:00:06PM -0400, Stephen Frost wrote: > diff --git a/doc/src/sgml/user-manag.sgml b/doc/src/sgml/user-manag.sgml > index d171b13236..fe0bdb7599 100644 > --- a/doc/src/sgml/user-manag.sgml > +++ b/doc/src/sgml/user-manag.sgml > @@ -518,6 +518,24 @@ DROP ROLE doomed_role

Re: New predefined roles- 'pg_read/write_all_data'

2021-04-05 Thread Stephen Frost
Greetings, * Stephen Frost (sfr...@snowman.net) wrote: > Updated patch attached. Will be playing with it a bit more but > generally feel like it's in pretty good shape. Unless there's anything > further on this, I'll likely commit it over the weekend. Weekend ended up being a bit busy, but I've

Re: New predefined roles- 'pg_read/write_all_data'

2021-04-01 Thread Stephen Frost
Greetings, * gkokola...@pm.me (gkokola...@pm.me) wrote: > On Monday, November 23, 2020 11:31 PM, Stephen Frost > wrote: > > - Anastasia Lubennikova (a.lubennik...@postgrespro.ru) wrote: > > > > > On 29.10.2020 17:19, Stephen Frost wrote: > > > > > > > - Georgios Kokolatos (gkokola...@protonm