| From: | "Chandra Barnett" <chandra(dot)barnett(at)cognition(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Alvaro Herrera" <alvherre(at)commandprompt(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Problem with roles and permissions |
| Date: | 2008-07-01 21:46:41 |
| Message-ID: | 8CB04B5A61D56040AE2E12F3172B290DAA5FA3@be30.exg3.exghost.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
That did it! Thanks, all.
(Out of curiosity, what's the reason for not making this the default? It seems to me that if you're making a role a child of another role, it's /because/ you want to inherit permissions. OTOH maybe defaulting to more security is smart enough to be worth the confusion...)
-cb.
> I think it's the other way around --- the login role needs the INHERIT property. Anyway, one or the other should do it.
regards, tom lane
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.526 / Virus Database: 270.4.3/1528 - Release Date: 7/1/2008 7:26 AM
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.526 / Virus Database: 270.4.3/1528 - Release Date: 7/1/2008 7:26 AM
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matt Magoffin | 2008-07-01 21:57:45 | Re: Memory use in 8.3 plpgsql with heavy use of xpath() |
| Previous Message | Tom Lane | 2008-07-01 21:31:17 | Re: Memory use in 8.3 plpgsql with heavy use of xpath() |