agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Marc Mitchell <marcm@eisolution.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Grant all to Public & adding users
Date: Thu, 10 Jan 2002 15:44:41 -0500
Message-ID: <22447.1010695481@sss.pgh.pa.us> (raw)
In-Reply-To: <010501c19a06$0e8d3120$620aa8c0@nmtransfer.com>
References: <010501c19a06$0e8d3120$620aa8c0@nmtransfer.com>

"Marc Mitchell" <marcm@eisolution.com> 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.  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?

It shouldn't behave that way, no.  PUBLIC isn't an explicit list of
users but an implicit "everybody" class.  I suspect you have
misdescribed your problem.  There have been other known bugs in
privilege-manipulation though.  What PG version are you using?
Can you give an exact example of a sequence that causes a problem?

			regards, tom lane

view thread (3+ messages)  latest in thread

Message-ID: <22447.1010695481@sss.pgh.pa.us>
Permalink:  ../22447.1010695481@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/22447.1010695481@sss.pgh.pa.us

reply

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-sql@postgresql.org
  Cc: tgl@sss.pgh.pa.us, marcm@eisolution.com, pgsql-admin@postgresql.org
  Subject: Re: Grant all to Public & adding users
  In-Reply-To: <22447.1010695481@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox