From: Richard Gbs <richardgbs@yahoo.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Permission issues. Please help
Date: Tue, 13 Mar 2018 22:52:37 +0000 (UTC)
Message-ID: <1773055302.387801.1520981557054@mail.yahoo.com> (raw)
References: <1773055302.387801.1520981557054.ref@mail.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: richardgbs@yahoo.com, pgsql-admin@lists.postgresql.org
Subject: Re: Permission issues. Please help
In-Reply-To: <1773055302.387801.1520981557054@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox