Create multiple users, to have all privileges on each others objects/relations

Поиск
Список
Период
Сортировка
От otar shavadze
Тема Create multiple users, to have all privileges on each others objects/relations
Дата
Msg-id CAG-jOyBFV-n+M=eS7oP4-wEizaHmVr9ZY2YfDCpU9_joQp9j6w@mail.gmail.com
обсуждение исходный текст
Ответы Re: Create multiple users, to have all privileges on each others objects/relations
Список pgsql-admin
Hello,
How can create multi users so, that they all have permissions on each others DB objects ?
What I did (From "postgres" user):

CREATE ROLE postgres_subuser1 PASSWORD 'some_password';
CREATE ROLE postgres_subuser2 PASSWORD 'some_password';

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;


Then  I logged in with "postgres_subuser1" and created table "table1".
Then  I logged in with "postgres_subuser2" and tried: "SELECT COUNT(*) FROM table1". This gives error:  "permission denied for table table1"

Tell please, What is my mistake?

В списке pgsql-admin по дате отправления:

Предыдущее
От: MichaelDBA
Дата:
Сообщение: Re: Pgpool for Pooling and Load Balancing
Следующее
От: Ron
Дата:
Сообщение: Re: Create multiple users, to have all privileges on each others objects/relations