Petr Jelinek napsal(a):
Tom Lane napsal(a):
Petr Jelinek <pjmo...@pjmodos.net> <mailto:pjmo...@pjmodos.net> writes:
Tom Lane napsal(a):
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.
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.
IIRC it just threw a warning, which didn't seem tremendously useful to
me.
Oh did it ? Then I must have discarded that idea for some reason. I
probably didn't want to be too pushy there.
Now I remember why - consistency with ACLs on object. REASSIGN OWNED
does not drop any GRANTed ACLs on any object, so it seemed appropriate
to only drop default ACLs in DROP OWNED BY along with ACLs on objects.
--
Regards
Petr Jelinek (PJMODOS)
