Postgres Pro
Downloads
Home   >   mailing lists

GRANT SELECT on all the partitions? - Mailing list pgsql-novice

From Sergey Samokhin
Subject GRANT SELECT on all the partitions?
Date
Msg-id e42595410909260852l211e86f2y44dca4fcacc16935@mail.gmail.com
Whole thread Raw
Responses Re: GRANT SELECT on all the partitions?
List pgsql-novice
Tree view 
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.

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

pgsql-novice by date:

Previous
From: Sergey Samokhin
Date:
Subject: Are trigger functions able to generate table name dynamically?
Next
From: Tom Lane
Date:
Subject: Re: text field slow to display in pgadmin