Re: [RFC] grants vs. inherited tables

On Mon, Jan 02, 2012 at 12:31:13PM +0100, Dimitri Fontaine wrote:
> Marko Kreen <markokr(at)gmail(dot)com> writes:
> > I tried to generalize a function that creates partitions
> > for a table and found out it's impossible to do it for grants.
> >
> > Basically, what I want is a child table that takes it's grants
> > from parent table. IMHO quite reasonable request. But I don't
> > see a way to do it in pl/pgsql. (Writing parser in plpgsql
> > for aclitemout() output does not count.)
>
> We solved that manually in https://github.com/slardiere/PartMgr, maybe
> you will find it useful for pre-9.2 releases. See function
> partition.grant() and partition.setgrant() in part_api.sql.

Thanks, thats interesting. Here is my current state:

https://github.com/markokr/skytools/blob/master/sql/dispatch/create_partition.sql

which uses info-schema for grants, which seems nicer than
parsing, but still not as nice as "including all".

--
marko