Thank for your answer David. This is what I'll do. ________________________________ De : David G. Johnston <david.g.johns...@gmail.com> Envoyé : 13 juillet 2020 19:46 À : Jean-Philippe Chenel <jp.che...@live.ca> Cc : pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org> Objet : Re: Both side privileges
On Mon, Jul 13, 2020 at 4:42 PM Jean-Philippe Chenel <jp.che...@live.ca<mailto:jp.che...@live.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.