| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Anj Adu <fotographs(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: permissions on inherited tables |
| Date: | 2009-06-17 22:00:42 |
| Message-ID: | dcc563d10906171500i54ca388dgb3ac8ad3a8e6f145@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, Jun 17, 2009 at 3:55 PM, Anj Adu<fotographs(at)gmail(dot)com> wrote:
> I have a bunch of tables which have child table that are partitions (several
> of them). Is there a way I can create a user with SELECT permissions on the
> parent without having to individually give the same permission on all child
> tables ? Every time I create new partitions..I have to explicitly grant
> permissions on the child tables. I use postgres 8.1.9. Is there a plan to
> fix this in a future release.
I believe that strictly speaking, it's not considered broken. Would
be nice to have a keyword when using inherits that would inherit the
perms as well though. So, "inherits (parent) with perms" or something
like that. Just a thought.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-06-17 22:46:01 | Re: permissions on inherited tables |
| Previous Message | Anj Adu | 2009-06-17 21:55:31 | permissions on inherited tables |