On Wed, Jun 17, 2009 at 3:55 PM, Anj Adu<fotographs@xxxxxxxxx> 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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
