On Sunday, November 15, 2020, Ron <
ronljohnsonjr@gmail.com> wrote:
On 11/15/20 9:46 AM, otar shavadze wrote:
How can create multi users so, that they all have permissions on each others DB objects ?
ALTER DEFAULT PRIVILEGES FOR ROLE postgres_subuser1 GRANT ALL PRIVILEGES ON TABLES TO postgres_subuser1;
ALTER DEFAULT PRIVILEGES FOR ROLE postgres_subuser2 GRANT ALL PRIVILEGES ON TABLES TO postgres_subuser2;
Tell please, What is my mistake?
You aren’t cross-authorizing: the context role and target role in each command is the same role.
Try creating a "group" role, and then "user" roles which inherit from the "group" role.
That is indeed the more common way of accomplishing the stated goal.
David J.