On Thu, Aug 24, 2023 at 11:34 AM Erik Wienhold wrote:
> > On 24/08/2023 10:11 CEST Dominique Devienne wrote:
> > On Wed, Aug 23, 2023 at 7:46 PM Tom Lane wrote:
> > > The readwrite user (not the admin) would need to issue ALTER DEFAULT
> > > PRIVILEGES granting that.
>
> > And I don't remembe
> On 24/08/2023 10:11 CEST Dominique Devienne wrote:
>
> On Wed, Aug 23, 2023 at 7:46 PM Tom Lane wrote:
> >
> > The readwrite user (not the admin) would need to issue ALTER DEFAULT
> > PRIVILEGES granting that.
>
> Hi. I'm confused Tom. Why should it matter who created the new tables?
>
> I'm al
On Wed, Aug 23, 2023 at 7:46 PM Tom Lane wrote:
> Hellen Jiang writes:
> > I have created readonly and readwrite roles with the following grants:
> however, readonly user does not have access to the new tables created by
> readwrite user. (readonly user has the access to new tables created by
>
On Thu, Aug 24, 2023 at 2:49 AM Marcos Pegoraro wrote:
>
> Have you tried grant pg_read_all_data to readonly ?
>
I tried. seems pg_read_all_data really means "read all data no matter what".
so you cannot grant pg_read_all_data then revoke certain schema privileges.
begin;
create user my_user
On 8/23/23 13:23, Hellen Jiang wrote:
Sorry it is a typo in the email. My readonly role is dbreadonly. It
works well so far except no access to new tables created by read write
role. It has access to new tables created by admin role.
I granted dbreadonly as the following:
-- Read-only role
23, 2023 at 1:57 PM
To: Hellen Jiang ,
pgsql-general@lists.postgresql.org
Subject: Re: Read only user permission
> On 23/08/2023 18:42 CEST Hellen Jiang wrote:
>
> I have created readonly and readwrite roles with the following grants:
> however, readonly user does not have acces
> On 23/08/2023 18:42 CEST Hellen Jiang wrote:
>
> I have created readonly and readwrite roles with the following grants:
> however, readonly user does not have access to the new tables created by
> readwrite user. (readonly user has the access to new tables created by admin).
> Any idea how I can
Hellen Jiang writes:
> I have created readonly and readwrite roles with the following grants:
> however, readonly user does not have access to the new tables created by
> readwrite user. (readonly user has the access to new tables created by admin).
> Any idea how I can grant the access to reado
Have you tried grant pg_read_all_data to readonly ?
regards
Marcos
Em qua., 23 de ago. de 2023 às 14:30, Hellen Jiang <
hji...@federatedwireless.com> escreveu:
> Hi,
>
>
>
> I have created readonly and readwrite roles with the following grants:
> however, readonly user does not have access to th
Hi,
I have created readonly and readwrite roles with the following grants: however,
readonly user does not have access to the new tables created by readwrite user.
(readonly user has the access to new tables created by admin).
Any idea how I can grant the access to readonly to make sure it has t
10 matches
Mail list logo
