From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
To: | Sergey Samokhin <prikrutil(at)gmail(dot)com> |
Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: GRANT SELECT on all the partitions? |
Date: | 2009-09-26 18:27:41 |
Message-ID: | 264855a00909261127x6d2b4daavf4cb57f13aadcc72@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Sat, Sep 26, 2009 at 11:52 AM, Sergey Samokhin <prikrutil(at)gmail(dot)com> wrote:
> Hello.
>
> Suppose that I have created a few dozens of partitions which all
> inherit from a single master table. Is there a way to GRANT SELECT on
> all these child tables by using a single SQL command? Having to issue
> a few dozens of similar but different GRANTs makes me tremble.
I don't think so. I would suggest using something like pgadminIII to
do this kind of thing. You just select the tables and then you can do
batch changes like grants.
Sean
> Something like the followind pseudocode could be the solution:
>
> GRANT SELECT ON TABLES INHERITED FROM master_table;
>
> How do people manage their batch of partitions?
>
> --
> Sergey Samokhin
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sergey Samokhin | 2009-09-27 17:55:48 | Re: GRANT SELECT on all the partitions? |
Previous Message | Tom Lane | 2009-09-26 16:05:54 | Re: text field slow to display in pgadmin |