| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Marc Mitchell" <marcm(at)eisolution(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Grant all to Public & adding users |
| Date: | 2002-01-10 20:44:41 |
| Message-ID: | 22447.1010695481@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
"Marc Mitchell" <marcm(at)eisolution(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2002-01-10 20:50:31 | Re: Grant all to Public & adding users |
| Previous Message | Marc Mitchell | 2002-01-10 18:38:49 | Grant all to Public & adding users |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2002-01-10 20:50:31 | Re: Grant all to Public & adding users |
| Previous Message | Wei Weng | 2002-01-10 20:33:46 | Re: Resources |