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.
