Date: Tue, 13 Mar 2018 22:52:37 +0000 (UTC)
From: Richard Gbs <richardgbs@yahoo.com>
To: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Message-ID: <1773055302.387801.1520981557054@mail.yahoo.com>
Subject: Permission issues. Please help
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_387800_91336221.1520981557053"
References: <1773055302.387801.1520981557054.ref@mail.yahoo.com>
Content-Length: 2035
Precedence: bulk

------=_Part_387800_91336221.1520981557053
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

I am stumped.
I have been trying to create some users/roles with privs and am having no l=
uck. I have tried all the combinations of alter, grants etc with no luck.
Here is my issues.
database "mydb" in schema "public" is owned=C2=A0 user1
there is also a user2 and user3=C2=A0
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 create=
s a table user1 and user3 get permission denied. etc ...
I need to have user1,2 and 3 have all the same privileges against any obeje=
ct in the database created by any of them.
Can someone give a high level approach to this please?
thanks
RG
------=_Part_387800_91336221.1520981557053
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div style=3D"font-family:Helvetica Neue, Helvetic=
a, Arial, sans-serif;font-size:16px;"><div>I am stumped.</div><div><br></di=
v><div>I have been trying to create some users/roles with privs and am havi=
ng no luck. I have tried all the combinations of alter, grants etc with no =
luck.</div><div><br></div><div>Here is my issues.</div><div><br></div><div>=
database "mydb" in schema "public" is owned&nbsp; user1</div><div><br></div=
><div>there is also a user2 and user3&nbsp;</div><div><br></div><div>The pr=
oblem is that if user1 create a table in the database user2 and user3 get p=
ermission denied for selects and inserts. etc ... And if user2 creates a ta=
ble user1 and user3 get permission denied. etc ...</div><div><br></div><div=
>I need to have user1,2 and 3 have all the same privileges against any obej=
ect in the database created by any of them.</div><div><br></div><div>Can so=
meone give a high level approach to this please?</div><div><br></div><div>t=
hanks</div><div><br></div><div>RG</div></div></body></html>
------=_Part_387800_91336221.1520981557053--