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.