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?
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2009-09-26 16:05:54|
|Subject: Re: text field slow to display in pgadmin |
|Previous:||From: Sergey Samokhin||Date: 2009-09-26 13:51:54|
|Subject: Are trigger functions able to generate table name dynamically?|