Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Eisentraut
Subject Re: Grant all to Public & adding users
Date
Msg-id Pine.LNX.4.30.0201101545560.749-100000@peter.localdomain
Whole thread Raw
In response to Grant all to Public & adding users  ("Marc Mitchell" <marcm@eisolution.com>)
List pgsql-admin
Tree view 
Marc Mitchell writes:

> 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.

I cannot reproduce this in 7.0.2 or in current, so either you are using an
even older version, in which case it's highly recommended to upgrade
(latest stable is 7.1.3), or you are confusing something, in which case
you should show the exact statements you are issuing and explain what you
wanted to happen in each case.

--
Peter Eisentraut   peter_e@gmx.net

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Grant all to Public & adding users
Next
From: Peter Wood
Date:
Subject: Installing Postgres v7.1.3 with support for Greek Characters