From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Privileges and inheritance |
Date: | 2009-10-05 18:23:43 |
Message-ID: | 1254767023.22144.0.camel@vanquo.pezone.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, 2009-10-05 at 11:45 +0100, Simon Riggs wrote:
> On Mon, 2009-10-05 at 13:06 +0300, Peter Eisentraut wrote:
> > On Mon, 2009-10-05 at 10:47 +0100, Simon Riggs wrote:
> > > top level: data-template
> > > main tables: data, data-recent both inherit from data-template
> > > all partitions inherit from data
> > > only recent partitions inherit from data-recent
> > > grants are issued on data and data-recent
> >
> > I don't see where the problem is here.
>
> In your last post you said it was necessary to use ONLY to address the
> required partitions and so setup would be weird. I am showing that this
> is not required and the setup is smooth.
Well, you posted this:
top level: data-template
main tables: data, data-recent both inherit from data-template
all partitions inherit from data
only recent partitions inherit from data-recent
grants are issued on data and data-recent
But this is too vague for me to make out who can read what and what
would change under the proposed change and why that would be a problem.
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2009-10-05 18:42:42 | Re: Privileges and inheritance |
Previous Message | Joe Conway | 2009-10-05 17:46:03 | Re: dblink memory leak |