From: | Jean-Philippe Chenel <jp(dot)chenel(at)live(dot)ca> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
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-14 13:36:34 |
Message-ID: | DM6PR10MB2921CDBEC0924127E6811DB8FD610@DM6PR10MB2921.namprd10.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Toomas Kristin | 2020-07-14 13:59:20 | Re: Both side privileges |
Previous Message | Thomas Kellerer | 2020-07-14 13:26:36 | Re: JDBC driver version for a given Postgres version |