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 user1
there is also a user2 and user3
The 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?