Re: Permission issues. Please help

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(at)yahoo(dot)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 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?
>
> thanks
>
> RG
>