Re: [PATCH] DefaultACLs - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCH] DefaultACLs
Date
Msg-id 29735.1254418634@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCH] DefaultACLs  (Petr Jelinek <pjmodos@pjmodos.net>)
Responses Re: [PATCH] DefaultACLs
Re: [PATCH] DefaultACLs
List pgsql-hackers
Petr Jelinek <pjmodos@pjmodos.net> writes:
> because it seems like merging privileges seems to be acceptable for most 
> (although I am not sure I like it, but I don't have better solution for 
> managing conflicts), I changed the patch to do just that.

It's not clear to me whether we have consensus on this approach.
Last chance for objections, anyone?

The main argument I can see against doing it this way is that it doesn't
provide a means for overriding the hard-wired public grants for object
types that have such (principally functions).  I think that a reasonable
way to address that issue would be for a follow-on patch that allows
changing the hard-wired default privileges for object types.  It might
well be that no one cares enough for it to matter, though.  I think that
in most simple cases what's needed is a way to add privileges, not
subtract them --- and we're already agreed that this mechanism is only
meant to simplify simple cases.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Rejecting weak passwords
Next
From: Tom Lane
Date:
Subject: Re: Limit allocated memory per session