Re: Permission issues. Please help
| От | Azimuddin Mohammed |
|---|---|
| Тема | Re: Permission issues. Please help |
| Дата | |
| Msg-id | CAKUuFd7SvF-fP5j9x0_HMOC-we4sbeMzB=R_w-03dNwm2sH4sw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Permission issues. Please help (Richard Gbs <richardgbs@yahoo.com>) |
| Список | pgsql-admin |
Look up role in postgres , you can create a role and users to that role and give permission to the role.
On Mar 13, 2018 10:25 PM, "Richard Gbs" <richardgbs@yahoo.com> wrote:
I am stumped.I have been trying to create some users/roles with privs and am having no luck. I have tried all the combinations of alter, grants etc with no luck.Here is my issues.database "mydb" in schema "public" is owned user1there is also a user2 and user3The problem is that if user1 create a table in the database user2 and user3 get permission denied for selects and inserts. etc ... And if user2 creates a table user1 and user3 get permission denied. etc ...I need to have user1,2 and 3 have all the same privileges against any obeject in the database created by any of them.Can someone give a high level approach to this please?thanksRG
В списке pgsql-admin по дате отправления: