Re: Both side privileges

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Jean-Philippe Chenel <jp(dot)chenel(at)live(dot)ca>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Both side privileges
Date: 2020-07-13 23:46:08
Message-ID: CAKFQuwbAB1pEvbpz7u1oAMg5ihBu5u=LX8=_VWFSKMpiTQhF-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jul 13, 2020 at 4:42 PM Jean-Philippe Chenel <jp(dot)chenel(at)live(dot)ca>
wrote:

> Hi,
>
> I try to give userA privileges on userB objects and same thing to the
> userB, giving privileges on userA objects.
>
> Grant userB to userA; —ok
> Grant userA to userB; —error: role userB is already member of role userA
>

Create a "group role" that retains ownership and then add both users to
that group.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-07-14 00:37:57 Re: backup -restore question
Previous Message Jean-Philippe Chenel 2020-07-13 23:42:08 Both side privileges