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@xxxxxxxxx> 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
