| From: | Cathy Mullican <cmullican(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PATCH] DefaultACLs |
| Date: | 2009-09-28 23:25:26 |
| Message-ID: | a92c54c30909281625x569ce582p2d0aa997c657fdc3@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 9/28/09, Josh Berkus <josh(at)agliodbs(dot)com> wrote
>
> > I already mentioned one case that there's longstanding demand for, which
> > is to instantiate the correct permissions on new partition child tables.
>
> Wouldn't that be handled by inheritance?
I wish, but no:
http://www.postgresql.org/docs/current/interactive/ddl-inherit.html
The first paragraph under "5.8.1 Caveats":
Table access permissions are not automatically inherited. Therefore, a user
attempting to access a parent table must either have permissions to do the
same operation on all its child tables as well, or must use the
ONLYnotation. When adding a new child table to an existing inheritance
hierarchy, be careful to grant all the needed permissions on it.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-09-28 23:26:52 | Re: Rejecting weak passwords |
| Previous Message | Tom Lane | 2009-09-28 23:23:45 | Re: [PATCH] DefaultACLs |