Postgres Pro
Downloads
Home   >   mailing lists

Re: Both side privileges - Mailing list pgsql-general

From David G. Johnston
Subject Re: Both side privileges
Date
Msg-id CAKFQuwbAB1pEvbpz7u1oAMg5ihBu5u=LX8=_VWFSKMpiTQhF-Q@mail.gmail.com
Whole thread Raw
In response to Both side privileges  (Jean-Philippe Chenel <jp.chenel@LIVE.CA>)
Responses Re: Both side privileges
List pgsql-general
Tree view
On Mon, Jul 13, 2020 at 4:42 PM Jean-Philippe Chenel <jp.chenel@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.

pgsql-general by date:

Previous
From: Jean-Philippe Chenel
Date:
Subject: Both side privileges
Next
From: Adrian Klaver
Date:
Subject: Re: backup -restore question