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

permissions on inherited tables

From: <sriram(dot)dandapani(at)bt(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: permissions on inherited tables
Date: 2008-03-21 19:57:23
Message-ID: 6A53198A90557543BA29A0F1FA19F6860340A6DA@E03MVW3-UKDY.domain1.systemhost.net (view raw or flat)
Thread:
Lists: pgsql-admin
Is there a way to grant a permission on a table for a role and have that
cascade to the child tables ?

 

I have several high volume "daily" partitioned tables that get dropped
every week and every time I need to re-grant permission on the new
tables created. 

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-03-23 03:01:33
Subject: Re: Postgres Performance
Previous:From: Steve CrawfordDate: 2008-03-21 19:50:10
Subject: Re: Postgres Performance

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