agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedGrant all to Public & adding users
3+ messages / 3 participants
[nested] [flat]
* Grant all to Public & adding users
@ 2002-01-10 18:38 Marc Mitchell <marcm@eisolution.com>
0 siblings, 2 replies; 3+ messages in thread
From: Marc Mitchell @ 2002-01-10 18:38 UTC (permalink / raw)
To: pgsql-admin@postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Grant all to Public & adding users
@ 2002-01-10 20:44 Tom Lane <tgl@sss.pgh.pa.us>
parent: Marc Mitchell <marcm@eisolution.com>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2002-01-10 20:44 UTC (permalink / raw)
To: Marc Mitchell <marcm@eisolution.com>; +Cc: pgsql-admin@postgresql.org
"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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Grant all to Public & adding users
@ 2002-01-10 20:50 Peter Eisentraut <peter_e@gmx.net>
parent: Marc Mitchell <marcm@eisolution.com>
1 sibling, 0 replies; 3+ messages in thread
From: Peter Eisentraut @ 2002-01-10 20:50 UTC (permalink / raw)
To: Marc Mitchell <marcm@eisolution.com>; +Cc: pgsql-admin@postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-01-10 20:50 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-01-10 18:38 Grant all to Public & adding users Marc Mitchell <marcm@eisolution.com>
2002-01-10 20:44 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-01-10 20:50 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox