Re: [PATCH] DefaultACLs

Tom Lane napsal(a):
> Petr Jelinek <pjmodos(at)pjmodos(dot)net> writes:
>
>> [ latest default-ACLs patch ]
>>
>
> Applied with a fair amount of editorial polishing. Notably I changed
> the permissions requirements a bit:
>

Thank you very much Tom.

> One thing that seems like it's likely to be an annoyance in practice
> is the need to explicitly do DROP OWNED BY to get rid of pg_default_acl
> entries for a role to be dropped. But I can't see any very good way
> around that, since the entries might be in some other database. One
> thing that might at least reduce the number of keystrokes is to have
> REASSIGN OWNED act as DROP OWNED BY for default ACLs. I can't convince
> myself whether that's a good idea though, so I left it as-is for the
> moment.
>

Yeah I am not happy about this either but there is not much we can do
about it. Btw I think in the version I sent in REASSIGN OWNED acted as
DROP OWNED for default ACLs.

--
Regards
Petr Jelinek (PJMODOS)