Grant all to Public & adding users - Mailing list pgsql-admin

From Marc Mitchell
Subject Grant all to Public & adding users
Date
Msg-id 010501c19a06$0e8d3120$620aa8c0@nmtransfer.com
Whole thread Raw
Responses Re: Grant all to Public & adding users
Re: Grant all to Public & adding users
List pgsql-admin
We have existing database where several tables have GRANT ALL TO PUBLIC.
However, when new users are added, they seem to get privilege problem until
another GRANT ALL TO PUBLIC is issued.  If this is truly the case (and
we're not crazy) then each time a new user is added, new GRANTs will have
to be executed.  Is this correct?  Is this intentional?  Anyone know a work
around?

MM


pgsql-admin by date:

Previous
From: Warren Bakker
Date:
Subject: data type comparable to Oracle RAW LONG
Next
From: Tom Lane
Date:
Subject: Re: Grant all to Public & adding users