Re: Both side privileges

2020-07-14 Thread Toomas Kristin
e...@live.ca>> > Cc : pgsql-general@lists.postgresql.org > <mailto:pgsql-general@lists.postgresql.org> > <mailto:pgsql-general@lists.postgresql.org>> > Objet : Re: Both side privileges > > On Mon, Jul 13, 2020 at 4:42 PM Jean-Philippe Chenel <mailto:jp.che...@live.ca

Re: Both side privileges

2020-07-14 Thread Jean-Philippe Chenel
Thank for your answer David. This is what I'll do. De : David G. Johnston Envoyé : 13 juillet 2020 19:46 À : Jean-Philippe Chenel Cc : pgsql-general@lists.postgresql.org Objet : Re: Both side privileges On Mon, Jul 13, 2020 at 4:42 PM Jean-Philippe C

Re: Both side privileges

2020-07-13 Thread David G. Johnston
On Mon, Jul 13, 2020 at 4:42 PM Jean-Philippe Chenel 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 > Crea

Both side privileges

2020-07-13 Thread Jean-Philippe Chenel
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 How can I do that? With best regards,