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

Re: [PATCH] DefaultACLs

From: Cathy Mullican <cmullican(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCH] DefaultACLs
Date: 2009-09-28 23:25:26
Message-ID: (view raw or whole thread)
Lists: pgsql-hackers
On 9/28/09, Josh Berkus <josh(at)agliodbs(dot)com> wrote
> > I already mentioned one case that there's longstanding demand for, which
> > is to instantiate the correct permissions on new partition child tables.
> Wouldn't that be handled by inheritance?

I wish, but no:
The first paragraph under "5.8.1 Caveats":
Table access permissions are not automatically inherited. Therefore, a user
attempting to access a parent table must either have permissions to do the
same operation on all its child tables as well, or must use the
ONLYnotation. When adding a new child table to an existing inheritance
hierarchy, be careful to grant all the needed permissions on it.

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-09-28 23:26:52
Subject: Re: Rejecting weak passwords
Previous:From: Tom LaneDate: 2009-09-28 23:23:45
Subject: Re: [PATCH] DefaultACLs

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