Re: [RFC] grants vs. inherited tables

Marko Kreen <markokr@gmail.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.

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support