Re: Both side privileges

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Mon, Jul 13, 2020 at 4:42 PM Jean-Philippe Chenel <jp.chenel@xxxxxxx> 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.