Skip site navigation (1) Skip section navigation (2)

Re: [RFC] grants vs. inherited tables

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Marko Kreen <markokr(at)gmail(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [RFC] grants vs. inherited tables
Date: 2011-12-30 02:11:22
Message-ID: 1325210757-sup-8408@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-hackers
Excerpts from Marko Kreen's message of jue dic 29 15:22:49 -0300 2011:
> 
> On Thu, Dec 29, 2011 at 03:12:50PM -0300, Alvaro Herrera wrote:
> > Excerpts from Marko Kreen's message of jue dic 29 15:04:49 -0300 2011:
> > > 3) Have a way to format aclitem into something
> > >    that can used to create GRANT statement easily.  Eg:
> > > 
> > >      pg_get_privilege_info(
> > >           IN priv aclitem,
> > >       OUT rolename text,
> > >       OUT privlist text[],
> > >       OUT privlist_with_grant_option text[]);
> > > 
> > >    This allows doing complex introspection in pl/pgsql
> > >    and also helps tools that want to re-create table structure
> > >    in other databases.
> > 
> > aclexplode?
> 
> I guess that decides the name.  :)

I have the (hopefully wrong) impression that you're missing the fact
that it already exists, at least in 9.0.

I have a backported version of it we wrote for a customer, in case
you're interested on using it in previous releases.  Not that it's all
that difficult to write ...

-- 
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2011-12-30 03:40:19
Subject: Re: [NOVICE] index refuses to build
Previous:From: Peter GeogheganDate: 2011-12-30 02:03:14
Subject: Progress on fast path sorting, btree index creation time

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group