Thread: permissions on inherited tables

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.

Thank you

Sriram

On Wed, Jun 17, 2009 at 3:55 PM, Anj Adu<fotographs@gmail.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.

Scott Marlowe <scott.marlowe@gmail.com> writes:
> On Wed, Jun 17, 2009 at 3:55 PM, Anj Adu<fotographs@gmail.com> wrote:
>> 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.

It has been discussed, but I don't think there's a concrete plan to
change it (yet).

            regards, tom lane