Re: Both side privileges

Thank for your answer David.
This is what I'll do.
________________________________
De : David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
Envoyé : 13 juillet 2020 19:46
À : 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>
Objet : Re: Both side privileges

On Mon, Jul 13, 2020 at 4:42 PM Jean-Philippe Chenel <jp(dot)chenel(at)live(dot)ca<mailto: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.