Grant all to Public & adding users

From: "Marc Mitchell" <marcm(at)eisolution(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Grant all to Public & adding users
Date: 2002-01-10 18:38:49
Message-ID: 010501c19a06$0e8d3120$620aa8c0@nmtransfer.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-01-10 20:44:41 Re: Grant all to Public & adding users
Previous Message Warren Bakker 2002-01-10 14:59:04 data type comparable to Oracle RAW LONG

Browse pgsql-sql by date

  From Date Subject
Next Message Wei Weng 2002-01-10 20:33:46 Re: Resources
Previous Message Stephan Szabo 2002-01-10 16:12:12 Re: Resources